{"id":699,"date":"2021-11-20T14:16:43","date_gmt":"2021-11-20T05:16:43","guid":{"rendered":"http:\/\/kiyonagi.jp\/?p=699"},"modified":"2021-11-20T14:19:18","modified_gmt":"2021-11-20T05:19:18","slug":"herokupostgresql-%e3%81%ae%e3%83%90%e3%83%83%e3%82%af%e3%82%a2%e3%83%83%e3%83%97%e3%81%a8%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%abdb%e3%81%b8%e3%81%ae%e3%83%aa%e3%82%b9%e3%83%88%e3%82%a2","status":"publish","type":"post","link":"http:\/\/kiyonagi.jp\/?p=699","title":{"rendered":"HerokuPostgresql \u306e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3068\u30ed\u30fc\u30ab\u30ebDB\u3078\u306e\u30ea\u30b9\u30c8\u30a2"},"content":{"rendered":"\n<p>\uff11\uff0e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u5165\u624b<br>\u7ba1\u7406\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u6a5f\u80fd\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"571\" src=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2-1024x571.png\" alt=\"\" class=\"wp-image-702\" srcset=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2-1024x571.png 1024w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2-300x167.png 300w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2-768x428.png 768w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2-700x390.png 700w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-2.png 1254w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><br>\u3042\u308b\u3044\u306f\u30b3\u30de\u30f3\u30c9\u3067\u3084\u308b\u5834\u5408<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"317\" src=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3-1024x317.png\" alt=\"\" class=\"wp-image-703\" srcset=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3-1024x317.png 1024w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3-300x93.png 300w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3-768x238.png 768w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3-700x217.png 700w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-3.png 1216w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption><code>heroku pg:backups:capture DB\u540d --app \u30a2\u30d7\u30ea\u540d<\/code><\/figcaption><\/figure>\n\n\n\n<p>\uff12\uff0e\u30ed\u30fc\u30ab\u30ebpostgresql \u3078 \u30ea\u30b9\u30c8\u30a2<br>\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002<br><code>pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d newdb C:\\3e6ea7c6-bb94-465a-8c39-f6bd6dce4ce6<\/code><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"316\" src=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6-1024x316.png\" alt=\"\" class=\"wp-image-707\" srcset=\"http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6-1024x316.png 1024w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6-300x93.png 300w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6-768x237.png 768w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6-700x216.png 700w, http:\/\/kiyonagi.jp\/wp-content\/uploads\/2021\/11\/image-6.png 1209w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u610f\u5473\u306f\u6b21\u306e\u3068\u304a\u308a\u3002<br>&#8211;verbose\u3000\u5197\u9577\u30e2\u30fc\u30c9\u3001\u30b3\u30f3\u30bd\u30fc\u30eb\u3067\u8a73\u7d30\u8868\u793a\u3092\u898b\u308b\u305f\u3081\u3002<br>&#8211;clean\u3000\u30ea\u30b9\u30c8\u30a2\u524d\u306bDB\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u306e\u5168\u524a\u9664<br>&#8211;no-acl\u3000\u6a29\u9650\u306f\u5fa9\u5143\u3057\u306a\u3044<br>&#8211;no-owner\u3000\u5143\u306e\u6240\u6709\u8005\u60c5\u5831\u306f\u7121\u8996\uff08\u65b0\u30b9\u30ad\u30fc\u30de\u306e\u6240\u6709\u8005\u3092\u63a1\u7528\uff09<br>-h\u3000\u30a4\u30f3\u30dd\u30fc\u30c8\u30db\u30b9\u30c8<br>-U\u3000\u63a5\u7d9a\u30e6\u30fc\u30b6<br>-d\u3000\u30a4\u30f3\u30dd\u30fc\u30c8DB<br>\u6700\u5f8c\u306b\u30c0\u30f3\u30d7\u30d5\u30a1\u30a4\u30eb\u306e\u30d5\u30eb\u30d1\u30b9\u3092\u6307\u5b9a<br><br>\uff08\u53c2\u8003\uff09<a rel=\"noreferrer noopener\" href=\"https:\/\/www.postgresql.jp\/docs\/9.2\/app-pgrestore.html\" target=\"_blank\">https:\/\/www.postgresql.jp\/docs\/9.2\/app-pgrestore.html<\/a><br><br>\u4ee5\u4e0a<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uff11\uff0e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u5165\u624b\u7ba1\u7406\u30b3\u30f3\u30bd\u30fc\u30eb\u306b\u6a5f\u80fd\u304c\u7528\u610f\u3055\u308c\u3066\u3044\u308b\u3002 \uff12\uff0e\u30ed\u30fc\u30ab\u30ebpostgresql \u3078 \u30ea\u30b9\u30c8\u30a2\u6b21\u306e\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3002pg_restore &#8211;verbose &#8211;clean &#8211;no-acl &#8211;no-&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11,4],"tags":[],"class_list":["post-699","post","type-post","status-publish","format-standard","hentry","category-tech","category-4"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/posts\/699","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=699"}],"version-history":[{"count":6,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/posts\/699\/revisions"}],"predecessor-version":[{"id":711,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=\/wp\/v2\/posts\/699\/revisions\/711"}],"wp:attachment":[{"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=699"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=699"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/kiyonagi.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=699"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}