{"id":333,"date":"2013-01-16T12:29:15","date_gmt":"2013-01-16T06:29:15","guid":{"rendered":"http:\/\/alexeyka.zantsev.com\/?p=333"},"modified":"2013-01-20T11:14:46","modified_gmt":"2013-01-20T05:14:46","slug":"postgresql-database-backup-2","status":"publish","type":"post","link":"https:\/\/alexeyka.zantsev.com\/?p=333","title":{"rendered":"PostgreSQL Database Backup"},"content":{"rendered":"<p>For a single database <strong>mybase<\/strong> located on a server <strong>dbserver.local<\/strong>, from a user <strong>john<\/strong> :<\/p>\n<p><code>pg_dump -h dbserver.local -U john mybase > backup_db_mybase.`date +%Y.%m.%d`.sql<\/code><\/p>\n<p>This simple trick may do a <em>great<\/em> deal for you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For a single database mybase located on a server dbserver.local, from a user john : pg_dump -h dbserver.local -U john mybase > backup_db_mybase.`date +%Y.%m.%d`.sql This simple trick may do a great deal for you.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[106,94,93],"class_list":["post-333","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-backup","tag-postgresql","tag-sql"],"_links":{"self":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/333","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=333"}],"version-history":[{"count":4,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions"}],"predecessor-version":[{"id":335,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=\/wp\/v2\/posts\/333\/revisions\/335"}],"wp:attachment":[{"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alexeyka.zantsev.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}