\u6b63\u3057\u304f\u306f\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308b<\/p>
$ sudo -u postgres pg_dumpall -h \"\u79fb\u884c\u5143\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30db\u30b9\u30c8\" -p \u79fb\u884c\u5143\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30dd\u30fc\u30c8 --quote-all-identifiers | sudo -u postgres psql -h \"\u79fb\u884c\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30db\u30b9\u30c8\" -p \u79fb\u884c\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30dd\u30fc\u30c8<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368284628648316","object":{"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368284628648316","objectType":"comment","content":"
\u6b63\u3057\u304f\u306f\u3053\u3093\u306a\u611f\u3058\u306b\u306a\u308b<\/p>
$ sudo -u postgres pg_dumpall -h \"\u79fb\u884c\u5143\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30db\u30b9\u30c8\" -p \u79fb\u884c\u5143\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30dd\u30fc\u30c8 --quote-all-identifiers | sudo -u postgres psql -h \"\u79fb\u884c\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30db\u30b9\u30c8\" -p \u79fb\u884c\u5148\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30dd\u30fc\u30c8<\/p>","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368284628648316","status_net":{"notice_id":null},"inReplyTo":{"objectType":"note","id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368277208926490","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368277208926490"}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mstdn.yakitamago.info,2019-01-06:objectId=2244554:objectType=Conversation","notice_info":{"local_id":"1921686","source":"ostatus"}},"published":"2019-01-06T06:47:52+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368284628648316"},{"actor":{"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama","displayName":"\u3084\u304d\u305f\u307e :sabakan:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/5-96-20191101013634.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/5-48-20191101012647.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/5-24-20191101014321.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"5"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/5-96-20191101013634.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","summary":"\u666e\u6bb5\u4f7f\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306e\u304a\u77e5\u3089\u305b\u306f @info \u304b\u3089\u6d41\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u304c\u81f4\u547d\u50b7\u3092\u8ca0\u3063\u305f\u5834\u5408\u306f @yakitama \u304b\u3089\u30d8\u30eb\u30d7\u3092\u8981\u8acb\u3057\u307e\u3059\u3002 #Minecraft","url":"https:\/\/mstdn.yakitamago.info\/@yakitama","portablecontacts_net":{"preferredUsername":"yakitama","displayName":"\u3084\u304d\u305f\u307e :sabakan:","note":"\u666e\u6bb5\u4f7f\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306e\u304a\u77e5\u3089\u305b\u306f @info \u304b\u3089\u6d41\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u304c\u81f4\u547d\u50b7\u3092\u8ca0\u3063\u305f\u5834\u5408\u306f @yakitama \u304b\u3089\u30d8\u30eb\u30d7\u3092\u8981\u8acb\u3057\u307e\u3059\u3002 #Minecraft"}},"content":"
\u3053\u308c\u7d76\u5bfe\u5931\u6557\u3059\u308b\u3067\u3057\u3087<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368277208926490","object":{"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368277208926490","objectType":"comment","content":"
\u3053\u308c\u7d76\u5bfe\u5931\u6557\u3059\u308b\u3067\u3057\u3087<\/p>","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368277208926490","status_net":{"notice_id":null},"inReplyTo":{"objectType":"note","id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368276638436630","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368276638436630"}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mstdn.yakitamago.info,2019-01-06:objectId=2244554:objectType=Conversation","notice_info":{"local_id":"1921671","source":"ostatus"}},"published":"2019-01-06T06:45:59+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368277208926490"},{"actor":{"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama","displayName":"\u3084\u304d\u305f\u307e :sabakan:","status_net":{"avatarLinks":[{"url":"https:\/\/social.senooken.jp\/avatar\/5-96-20191101013634.png","rel":"avatar","type":"image\/png","width":96,"height":96},{"url":"https:\/\/social.senooken.jp\/avatar\/5-48-20191101012647.png","rel":"avatar","type":"image\/png","width":48,"height":48},{"url":"https:\/\/social.senooken.jp\/avatar\/5-24-20191101014321.png","rel":"avatar","type":"image\/png","width":24,"height":24}],"profile_info":{"local_id":"5"}},"image":{"url":"https:\/\/social.senooken.jp\/avatar\/5-96-20191101013634.png","rel":"avatar","type":"image\/png","width":96,"height":96},"objectType":"person","summary":"\u666e\u6bb5\u4f7f\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306e\u304a\u77e5\u3089\u305b\u306f @info \u304b\u3089\u6d41\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u304c\u81f4\u547d\u50b7\u3092\u8ca0\u3063\u305f\u5834\u5408\u306f @yakitama \u304b\u3089\u30d8\u30eb\u30d7\u3092\u8981\u8acb\u3057\u307e\u3059\u3002 #Minecraft","url":"https:\/\/mstdn.yakitamago.info\/@yakitama","portablecontacts_net":{"preferredUsername":"yakitama","displayName":"\u3084\u304d\u305f\u307e :sabakan:","note":"\u666e\u6bb5\u4f7f\u3044\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u306e\u304a\u77e5\u3089\u305b\u306f @info \u304b\u3089\u6d41\u3057\u307e\u3059\u3002\u30b5\u30fc\u30d0\u30fc\u304c\u81f4\u547d\u50b7\u3092\u8ca0\u3063\u305f\u5834\u5408\u306f @yakitama \u304b\u3089\u30d8\u30eb\u30d7\u3092\u8981\u8acb\u3057\u307e\u3059\u3002 #Minecraft"}},"content":"
> \u65b0\u3057\u3044\u30b5\u30fc\u30d0\u3092\u7570\u306a\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u53e4\u3044\u30b5\u30fc\u30d0\u3068\u65b0\u3057\u3044\u30b5\u30fc\u30d0\u3092\u5225\u306e\u30dd\u30fc\u30c8\u3067\u4e26\u884c\u3057\u3066\u5b9f\u884c\u3055\u305b\u308b\u3053\u3068\u3067\u3001\u505c\u6b62\u6642\u9593\u3092\u6700\u5c0f\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u3053\u306e\u5834\u5408\u3001\u30c7\u30fc\u30bf\u3092\u79fb\u884c\u3059\u308b\u305f\u3081\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
> pg_dumpall -p 5432 | psql -d postgres -p 5433<\/p>
\u306b\u5bfe\u3057\u3066\u3001psql \u306e\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/p>
-d dbname
> \u63a5\u7d9a\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002 \u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u30aa\u30d7\u30b7\u30e7\u30f3\u4ee5\u5916\u306e\u6700\u521d\u306e\u5f15\u6570\u3068\u3057\u3066dbname\u3092\u6307\u5b9a\u3059\u308b\u306e\u3068\u540c\u3058\u52b9\u529b\u3092\u6301\u3061\u307e\u3059\u3002<\/p>","generator":{"id":"tag:status.net,2009:notice-source:ostatus","objectType":"application","status_net":{"source_code":"ostatus"}},"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368276638436630","object":{"id":"https:\/\/mstdn.yakitamago.info\/users\/yakitama\/statuses\/101368276638436630","objectType":"note","content":"
> \u65b0\u3057\u3044\u30b5\u30fc\u30d0\u3092\u7570\u306a\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3001\u53e4\u3044\u30b5\u30fc\u30d0\u3068\u65b0\u3057\u3044\u30b5\u30fc\u30d0\u3092\u5225\u306e\u30dd\u30fc\u30c8\u3067\u4e26\u884c\u3057\u3066\u5b9f\u884c\u3055\u305b\u308b\u3053\u3068\u3067\u3001\u505c\u6b62\u6642\u9593\u3092\u6700\u5c0f\u306b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002 \u3053\u306e\u5834\u5408\u3001\u30c7\u30fc\u30bf\u3092\u79fb\u884c\u3059\u308b\u305f\u3081\u306b\u4ee5\u4e0b\u306e\u3088\u3046\u306a\u30b3\u30de\u30f3\u30c9\u3092\u4f7f\u7528\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002
> pg_dumpall -p 5432 | psql -d postgres -p 5433<\/p>
\u306b\u5bfe\u3057\u3066\u3001psql \u306e\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/p>
-d dbname
> \u63a5\u7d9a\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u540d\u524d\u3092\u6307\u5b9a\u3057\u307e\u3059\u3002 \u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u3067\u30aa\u30d7\u30b7\u30e7\u30f3\u4ee5\u5916\u306e\u6700\u521d\u306e\u5f15\u6570\u3068\u3057\u3066dbname\u3092\u6307\u5b9a\u3059\u308b\u306e\u3068\u540c\u3058\u52b9\u529b\u3092\u6301\u3061\u307e\u3059\u3002<\/p>","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368276638436630","status_net":{"notice_id":null}},"to":[{"objectType":"http:\/\/activitystrea.ms\/schema\/1.0\/collection","id":"http:\/\/activityschema.org\/collection\/public"}],"status_net":{"conversation":"tag:mstdn.yakitamago.info,2019-01-06:objectId=2244554:objectType=Conversation","notice_info":{"local_id":"1921669","source":"ostatus"}},"published":"2019-01-06T06:45:51+00:00","provider":{"objectType":"service","displayName":"senooken JP Social","url":"https:\/\/social.senooken.jp\/"},"verb":"post","url":"https:\/\/mstdn.yakitamago.info\/@yakitama\/101368276638436630"}],"links":[{"url":"https:\/\/social.senooken.jp\/conversation\/1361188","rel":"alternate","type":"text\/html"}]}