http:\/\/www.postgresql.jp\/document\/current\/html\/libpq-pgpass.html [1]<\/p>\n
\u5b9f\u884c\u3059\u308b\u30e6\u30fc\u30b6\u306e\u30db\u30fc\u30e0\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u300c.pgpass\u300d\u3092\u4f5c\u6210\u3002\uff08\u6a29\u9650600\uff09<\/p>\n
hostname:port:database:username:password<\/p>\n
\u306e\u9806\u3067\u8a18\u8ff0<\/p>\n
\u4f8b\uff09 localhost:5432:db:postges:password<\/p>\n
\u3053\u306e\u5f8c<\/p>\n
pg_dump -h localhost -U postgres db > dmp<\/p>\n
\u3068\u3044\u3063\u305f\u5f62\u3067\u5b9f\u884c\u3059\u308b\u3068\u81ea\u52d5\u7684\u306b\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u9001\u3089\u308c\u308b\u3002<\/p>\n
[1] http:\/\/www.postgresql.jp\/document\/current\/html\/libpq-pgpass.html<\/p>\n","protected":false},"excerpt":{"rendered":"
http:\/\/www.postgresql.jp\/document\/current\/html\/libpq-pgpass.html [1] \u5b9f\u884c\u3059\u308b\u30e6\u30fc\u30b6\u306e\u30db\u30fc\u30e0\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u300c.pgpass\u300d\u3092\u4f5c\u6210\u3002\uff08\u6a29\u9650600\uff09 ho […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"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":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[15],"tags":[],"class_list":["post-59","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":852,"url":"https:\/\/wp.kaz.bz\/tech\/2011\/06\/03\/852.html","url_meta":{"origin":59,"position":0},"title":"postfix + dovecot \u3067\u4eee\u60f3\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u3092\u4f5c\u6210\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3002","author":"kaz. Suenaga","date":"2011\/06\/03","format":false,"excerpt":"postfix + dovecot \u3067\u4eee\u60f3\u30e1\u30fc\u30eb\u30dc\u30c3\u30af\u30b9\u3092\u4f5c\u6210\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3002 \u30c6\u30b9\u30c8\u9001\u4fe1\uff0b\u53d7\u4fe1\u4ed8\u3002\u2026","rel":"","context":"postfix_dovecot","block_context":{"text":"postfix_dovecot","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/postfix_dovecot"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":426,"url":"https:\/\/wp.kaz.bz\/tech\/2010\/10\/25\/426.html","url_meta":{"origin":59,"position":1},"title":"\u30c0\u30f3\u30d7\u30fb\u30ea\u30b9\u30c8\u30a2","author":"kaz. Suenaga","date":"2010\/10\/25","format":false,"excerpt":"\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u306a\u3069\u3067\u5229\u7528\u3059\u308b\u969b\u306f\u3001\u30c0\u30f3\u30d7\u3082\u30ea\u30b9\u30c8\u30a2\u3082\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30b3\u30de\u30f3\u30c9\u304b\u3089\u53e4\u3044\u30d0\u30fc\u30b8\u30e7\u30f3\u306e\u30b5\u30fc\u2026","rel":"","context":"PostgreSQL","block_context":{"text":"PostgreSQL","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/db\/postgresql"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":16,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/05\/12\/16.html","url_meta":{"origin":59,"position":2},"title":"\u30bb\u30ab\u30f3\u30c9\u30aa\u30fc\u30c0\u30fcSQL\u30a4\u30f3\u30b8\u30a7\u30af\u30b7\u30e7\u30f3","author":"kaz. Suenaga","date":"2009\/05\/12","format":false,"excerpt":"\u53c2\u7167\uff09 http:\/\/blog.goo.ne.jp\/xmldtp\/e\/afe4908b1707d9b\u2026","rel":"","context":"\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3","block_context":{"text":"\u30bb\u30ad\u30e5\u30ea\u30c6\u30a3","link":"https:\/\/wp.kaz.bz\/tech\/category\/security"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/09\/17\/8.html","url_meta":{"origin":59,"position":3},"title":"vpgsql.c \u306e\u30d0\u30b0\u3002","author":"kaz. Suenaga","date":"2009\/09\/17","format":false,"excerpt":"vpopmail-5.4.28 \u3067\u3001 \u30fbDB\u306bPostgreSQL\u3092\u5229\u7528 \u30fbvalias \u3092DB\u3067\u5229\u2026","rel":"","context":"qmail \/ vpopmail","block_context":{"text":"qmail \/ vpopmail","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb\/qmail-vpopmail"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":50,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/03\/13\/50.html","url_meta":{"origin":59,"position":4},"title":"PostgreSQL\u306eARRAY\u95a2\u6570\u3002","author":"kaz. Suenaga","date":"2008\/03\/13","format":false,"excerpt":"SQL\u5b9f\u884c\u3059\u308b\u969b\u306b\u3001ARRAY()\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u914d\u5217\u3067\u7d50\u679c\u30bb\u30c3\u30c8\u304c\u5f97\u3089\u308c\u308b\u3002 \u4f8b\uff09 SELECT \u2026","rel":"","context":"PostgreSQL","block_context":{"text":"PostgreSQL","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/db\/postgresql"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":229,"url":"https:\/\/wp.kaz.bz\/tech\/2010\/09\/10\/229.html","url_meta":{"origin":59,"position":5},"title":"Evernote\u306e\u30af\u30ea\u30c3\u30d4\u30f3\u30b0\u6a5f\u80fd\u3002","author":"kaz. Suenaga","date":"2010\/09\/10","format":false,"excerpt":"Evernote \u3078\u306e\u30af\u30ea\u30c3\u30d7\u30b9\u30af\u30ea\u30d7\u30c8\u3002 \uff08\u516c\u5f0f\u306eBookmarklet\u306e\u5185\u5bb9\u3067\u3059\u3002\uff09 javas\u2026","rel":"","context":"\u3068\u308a\u3042\u3048\u305a\u30e1\u30e2","block_context":{"text":"\u3068\u308a\u3042\u3048\u305a\u30e1\u30e2","link":"https:\/\/wp.kaz.bz\/tech\/category\/memo_tmp"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/59","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/comments?post=59"}],"version-history":[{"count":0,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/59\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/media?parent=59"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/categories?post=59"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/tags?post=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}