{"id":8152,"date":"2015-03-04T03:46:00","date_gmt":"2015-03-03T19:46:00","guid":{"rendered":"https:\/\/ihower.tw\/blog\/?p=8152"},"modified":"2015-03-04T22:34:13","modified_gmt":"2015-03-04T14:34:13","slug":"postgresql-%e5%82%99%e4%bb%bd%e9%82%84%e5%8e%9f%e6%8c%87%e4%bb%a4","status":"publish","type":"post","link":"https:\/\/ihower.tw\/blog\/8152-postgresql-%e5%82%99%e4%bb%bd%e9%82%84%e5%8e%9f%e6%8c%87%e4%bb%a4","title":{"rendered":"PostgreSQL \u5099\u4efd\u9084\u539f\u6307\u4ee4"},"content":{"rendered":"<p><a href=\"http:\/\/www.postgresql.org\/\">PostgreSQL<\/a> \u5df2\u7d93\u6210\u70ba\u6211\u958b\u65b0\u5c08\u6848\u7684\u9996\u9078\u8cc7\u6599\u5eab\uff0c\u5099\u4efd\u9084\u539f\u6307\u4ee4\u8ddf\u4ee5\u524d\u719f\u6089\u7684 mysql \u4e0d\u4e00\u6a23\uff0c\u7d00\u9304\u4e00\u4e0b\u3002<\/p>\n<h3>\u5099\u4efd\u532f\u51fa<\/h3>\n<p>\u4f7f\u7528 <a href=\"http:\/\/www.postgresql.org\/docs\/9.4\/static\/app-pgdump.html\">pg_dump<\/a> \u6307\u4ee4\u3002<\/p>\n<pre>\npg_dump -W -U postgres -h localhost your_db_name > 20150304.sql\n<\/pre>\n<p>\u5176\u4e2d -U postgres \u662f\u8cc7\u6599\u5eab\u4f7f\u7528\u8005\u540d\u7a31\u3002<\/p>\n<h3>\u532f\u5165\u9084\u539f<\/h3>\n<p>\u4f7f\u7528 <a href=\"http:\/\/www.postgresql.org\/docs\/9.2\/static\/app-psql.html\">psql<\/a> \u6307\u4ee4\u3002<\/p>\n<pre>\nsudo service nginx stop\n\ndropdb  -W -U postgres -h localhost your_db_name \ncreatedb -W -U postgres -h localhost your_db_name\npsql  -W -U postgres -h localhost your_db_name < 20150304.sql\n\nsudo service nginx start\n<\/pre>\n<p>\u5982\u679c\u8981\u780d\u6389\u91cd\u73fe\u73fe\u6709\u7684\u8cc7\u6599\u5eab\uff0c\u7528 dropdb \u548c createdb \u6307\u4ee4\uff0c\u4e26\u4e14\u9700\u8981\u95dc\u9589\u6b63\u5728\u9023\u7dda\u7684\u61c9\u7528\uff0c\u4f8b\u5982 nginx \u7db2\u7ad9\u4f3a\u670d\u5668\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL \u5df2\u7d93\u6210\u70ba\u6211\u958b\u65b0\u5c08\u6848\u7684\u9996\u9078\u8cc7\u6599\u5eab\uff0c\u5099\u4efd\u9084\u539f\u6307\u4ee4\u8ddf\u4ee5\u524d\u719f\u6089\u7684 mysql \u4e0d\u4e00\u6a23\uff0c\u7d00\u9304\u4e00\u4e0b\u3002 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/ihower.tw\/blog\/8152-postgresql-%e5%82%99%e4%bb%bd%e9%82%84%e5%8e%9f%e6%8c%87%e4%bb%a4\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008PostgreSQL \u5099\u4efd\u9084\u539f\u6307\u4ee4\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[38],"tags":[],"class_list":["post-8152","post","type-post","status-publish","format-standard","hentry","category-database","entry"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p1q6tG-27u","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/posts\/8152","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/comments?post=8152"}],"version-history":[{"count":9,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/posts\/8152\/revisions"}],"predecessor-version":[{"id":8176,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/posts\/8152\/revisions\/8176"}],"wp:attachment":[{"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/media?parent=8152"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/categories?post=8152"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihower.tw\/blog\/wp-json\/wp\/v2\/tags?post=8152"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}