\u307e\u305f\u3042\u3063\u3068\u3044\u3046\u9593\u306b\u6642\u304c\u7d4c\u3063\u305f\u3002
\n\u5e2b\u8d70\u3060\u3002<\/p>\n
Windows\u30d0\u30c3\u30c1\u3067A\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u3092B\u30b5\u30fc\u30d0\u306b\u79fb\u3059\u3053\u3068\u306b\u3057\u305f\u3002<\/p>\n
\u3093\u3067\u3001\u3068\u308a\u3042\u3048\u305a\u3044\u308d\u3044\u308d\u53c2\u8003\u306b\u3057\u3066\u4f5c\u3063\u305f\u306e\u304c\u4e0b\u306e\u4f8b\u3002<\/p>\n
\u307e\u305a\u306f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u3044\u3066\u3001\u9014\u4e2d\u3067\u805e\u304b\u308c\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u304b\u3089\u30fb\u30fb\u30fb
\npg_dump \u3092\u4f7f\u3063\u3066 D:\\backup\\test.backup\u306b 111.111.111.111:5432 \u306eA1_DB\u3092\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u3002
\n(\u30e6\u30fc\u30b6\u306fpostgres)
\n\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30d5\u30a1\u30a4\u30eb\u304b\u3089pg_restore\u3092\u4f7f\u3063\u3066\u3001111.111.111.123:5432 \u306eA2_DB\u3078\u30ea\u30b9\u30c8\u30a2\u3002
\n(\u3053\u3063\u3061\u3082\u30e6\u30fc\u30b6\u306fpostgres)<\/p>\n
—————————————————————–
\nSET PGPASSWORD=password
\n“C:\\Program Files\\PostgreSQL\\9.3\\bin\\pg_dump.exe” -f D:\\backup\\test.backup -i -v -h 111.111.111.111 -p 5432 -U “postgres” -Fc “A1_DB”
\nif not %ERRORLEVEL%==0 stop <\/p>\n
“C:\\Program Files\\PostgreSQL\\9.3\\bin\\pg_restore.exe” -c -h 111.111.111.123 -p 5432 -U “postgres” -Fc -d “A2_DB” D:\\backup\\test.backup<\/p>\n
stop
\n—————————————————————–
\n\u30aa\u30d7\u30b7\u30e7\u30f3\u95a2\u9023\u306f\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3092\u898b\u3066\u3082\u3089\u3048\u3070\u3044\u3044\u3068\u601d\u3046\u3051\u3069\u3001\u66f8\u304d\u9806\u3084\u3089\u304c\u30c9\u30ad\u30e5\u30e1\u30f3\u30c8\u3067\u306f\u3044\u307e\u3044\u3061\u308f\u304b\u3089\u3093\u304b\u3063\u305f\u306e\u3067\u30e1\u30e2\u3063\u3068\u304f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u307e\u305f\u3042\u3063\u3068\u3044\u3046\u9593\u306b\u6642\u304c\u7d4c\u3063\u305f\u3002 \u5e2b\u8d70\u3060\u3002 Windows\u30d0\u30c3\u30c1\u3067A\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u3092B\u30b5\u30fc\u30d0\u306b\u79fb\u3059\u3053\u3068\u306b\u3057\u305f\u3002 \u3093\u3067\u3001\u3068\u308a\u3042\u3048\u305a\u3044\u308d\u3044\u308d\u53c2\u8003\u306b\u3057\u3066\u4f5c\u3063\u305f\u306e\u304c\u4e0b\u306e\u4f8b\u3002 \u307e\u305a\u306f\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u3066\u304a\u3044\u3066\u3001\u9014\u4e2d\u3067\u805e\u304b\u308c\u306a\u3044\u3088\u3046 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[184,66],"class_list":["post-2104","post","type-post","status-publish","format-standard","hentry","category-sql","tag-db","tag-postgresql"],"_links":{"self":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2104","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2104"}],"version-history":[{"count":1,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2104\/revisions"}],"predecessor-version":[{"id":2722,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=\/wp\/v2\/posts\/2104\/revisions\/2722"}],"wp:attachment":[{"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2104"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2104"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/anada.cloudfree.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2104"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}