{"id":127,"date":"2024-10-30T17:52:02","date_gmt":"2024-10-30T09:52:02","guid":{"rendered":"https:\/\/zhoujibin.com\/?p=127"},"modified":"2024-10-30T17:52:02","modified_gmt":"2024-10-30T09:52:02","slug":"pg%e6%95%b0%e6%8d%ae%e5%ba%93%e6%95%b0%e6%8d%ae%e5%a4%87%e4%bb%bd%e5%8f%8a%e8%bf%98%e5%8e%9f","status":"publish","type":"post","link":"https:\/\/zhoujibin.com\/?p=127","title":{"rendered":"PG\u6570\u636e\u5e93\u6570\u636e\u5907\u4efd\u53ca\u8fd8\u539f"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\">\u5907\u4efd\u6570\u636e<\/h1>\n\n\n\n<p>\u4f7f\u7528pg_dump \u547d\u4ee4\u5c06\u6570\u636e\u5e93\u6587\u4ef6\u5907\u4efd\u81f3\u6307\u5b9a\u76ee\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u521b\u5efa\u5907\u4efd\u6587\u4ef6\u7684\u5b58\u50a8\u4f4d\u7f6e\nmidir -p \/data\/backup\n# --host \u6307\u5b9a\u6570\u636e\u5e93\u6240\u5728\u7684\u673a\u5668\u5730\u5740 --port \u6570\u636e\u5e93\u7aef\u53e3 -- username \u6570\u636e\u5e93\u7528\u6237\u540d --dbname \u6570\u636e\u5e93\u540d\u79f0\n# --format \u6307\u5b9a\u5bfc\u51fa\u7684\u6587\u4ef6\u683c\u5f0f\uff0c\u9ed8\u8ba4\u4e3asql\u6587\u4ef6 --file \u6307\u5b9a\u5bfc\u51fa\u6587\u4ef6\u7684\u5730\u5740\uff0c\u6587\u4ef6\u540d\u5305\u62ec\u540e\u7f00\u53ef\u81ea\u5b9a\u4e49\uff0c\u6062\u590d\u6570\u636e\u65f6\u4fdd\u6301\u4e00\u81f4\u5373\u53ef\n# \u5176\u4f59\u53c2\u6570\u914d\u7f6e\u53ef\u67e5\u770b\uff1ahttp:\/\/postgres.cn\/docs\/9.6\/app-pgdump.html\npg_dump --host 192.168.1.1 --port 5432 --username \"user\"  --dbname \"test\"  --format custom --blobs  --encoding UTF8 --verbose --file \"\/data\/backup\/pg\/pg_20220818.backup\"<\/code><\/pre>\n\n\n\n<p>pg_dump\u4f7f\u7528\u53ef\u67e5\u770b\uff1a<a href=\"http:\/\/postgres.cn\/docs\/9.6\/app-pgdump.html\">pg_dump \u4f7f\u7528\u624b\u518c<\/a><\/p>\n\n\n\n<h1 class=\"wp-block-heading\">\u8fd8\u539f\u6570\u636e<\/h1>\n\n\n\n<p>\u4f7f\u7528pg_restore \u8fd8\u539f\u6570\u636e<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u5c06\u5907\u4efd\u6570\u636e\u4e0a\u4f20\u81f3\/data\/recover\uff0c\u4f9d\u6b21\u6267\u884c\u6062\u590d\u5907\u4efd\u547d\u4ee4\npg_restore --host 192.168.1.2 --port \"5432\" --username \"user\" -c --dbname \"test\" --verbose \"\/data\/recover\/pg_20220818.backup\"<\/code><\/pre>\n\n\n\n<p>pg_restore \u4f7f\u7528\u53ef\u67e5\u770b\uff1a<a href=\"http:\/\/www.postgres.cn\/docs\/9.3\/app-pgrestore.html\">pg_restore \u4f7f\u7528\u624b\u518c<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5907\u4efd\u6570\u636e \u4f7f\u7528pg_dump \u547d\u4ee4\u5c06\u6570\u636e\u5e93\u6587\u4ef6\u5907\u4efd\u81f3\u6307\u5b9a\u76ee\u5f55 pg_dump\u4f7f\u7528\u53ef\u67e5\u770b\uff1apg_dump \u4f7f\u7528\u624b [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[28],"class_list":["post-127","post","type-post","status-publish","format-standard","hentry","category-database","tag-pg"],"_links":{"self":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/127"}],"collection":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=127"}],"version-history":[{"count":1,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions"}],"predecessor-version":[{"id":128,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=\/wp\/v2\/posts\/127\/revisions\/128"}],"wp:attachment":[{"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=127"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=127"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zhoujibin.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=127"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}