{"id":2271,"date":"2015-09-24T02:55:58","date_gmt":"2015-09-23T17:55:58","guid":{"rendered":"http:\/\/tech.akat.info\/?p=2271"},"modified":"2015-09-24T02:55:58","modified_gmt":"2015-09-23T17:55:58","slug":"phppgadmin%e3%81%ab%e3%81%a6%e5%a4%96%e9%83%a8%e3%82%b5%e3%83%bc%e3%83%90%e3%81%aepostgre%e3%82%92%e6%93%8d%e4%bd%9c%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/tech.akat.info\/?p=2271","title":{"rendered":"phppgadmin\u306b\u3066\u5916\u90e8\u30b5\u30fc\u30d0\u306epostgre\u3092\u64cd\u4f5c\u3059\u308b"},"content":{"rendered":"<h1>\u63a5\u7d9a\u5143\u30b5\u30fc\u30d0\u8a2d\u5b9a<\/h1>\n<p>phppgadmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u63a5\u7d9a\u5148\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a<\/p>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nroot@hostname:\/home\/shimizu# cat \/etc\/debian_version\r\n8.2\r\nroot@hostname:\/home\/shimizu# aptitude install phppgadmin\r\n...\r\n\r\nroot@hostname:\/home\/shimizu# vi \/etc\/apache2\/sites-enabled\/000-default.conf\r\n...\r\n### \u4ee5\u4e0b\u3092\u8ffd\u8a18\u3059\u308b ###\r\nAlias \/phppgadmin \/usr\/share\/phppgadmin\r\n...\r\n\r\nroot@hostname:\/home\/shimizu# vi \/etc\/phppgadmin\/config.inc.php\r\n...\r\n### \u4ee5\u4e0b\u3092\u8ffd\u8a18\u3059\u308b ###\r\n        \/\/ Example for a second server (PostgreSQL for Windows)\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'desc'] = 'Test Server';\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'host'] = '104.199.129.118';\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'port'] = 5432;\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'sslmode'] = 'allow';\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'defaultdb'] = 'template1';\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'pg_dump_path'] = '\/usr\/bin\/pg_dump';\r\n        $conf&#x5B;'servers']&#x5B;1]&#x5B;'pg_dumpall_path'] = '\/usr\/bin\/pg_dumpall';\r\n        \/\/$conf&#x5B;'servers']&#x5B;1]&#x5B;'pg_dump_path'] = 'C:\\\\Program Files\\\\PostgreSQL\\\\8.0\\\\bin\\\\pg_dump.exe';\r\n        \/\/$conf&#x5B;'servers']&#x5B;1]&#x5B;'pg_dumpall_path'] = 'C:\\\\Program Files\\\\PostgreSQL\\\\8.0\\\\bin\\\\pg_dumpall.exe';\r\n\r\n### \u4ee5\u4e0b\u3092\u5909\u66f4\u3059\u308b(\u3053\u3053\u3092\u5909\u66f4\u3057\u306a\u3044\u3068postgres\u30e6\u30fc\u30b6\u3067\u306f\u63a5\u7d9a\u3067\u304d\u306a\u3044) ###\r\n        $conf&#x5B;'extra_login_security'] = false;\r\n...\r\n\r\n<\/pre>\n<h1>\u63a5\u7d9a\u5148\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a<\/h1>\n<pre class=\"brush: plain; title: ; notranslate\" title=\"\">\r\nroot@ubuntu14:\/home\/ubuntu# vi \/etc\/postgresql\/9.3\/main\/postgresql.conf\r\n...\r\nlisten_addresses = '*'\r\n...\r\n\r\nroot@ubuntu14:\/home\/ubuntu# vi \/etc\/postgresql\/9.3\/main\/pg_hba.conf\r\n...\r\nhost    all             all             &#x5B;\u63a5\u7d9a\u5143IP\u30a2\u30c9\u30ec\u30b9]\/32        trust\r\n...\r\n\r\nroot@ubuntu14:\/home\/ubuntu# \/etc\/init.d\/postgresql restart\r\n * Restarting PostgreSQL 9.3 database server                                                        &#x5B; OK ]\r\n<\/pre>\n<p>\u7121\u4e8b\u306b\u63a5\u7d9a\u3067\u304d\u305f<br \/>\n<a href=\"http:\/\/tech.akat.info\/wp-content\/uploads\/2015\/09\/2015-09-24_022613.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/tech.akat.info\/wp-content\/uploads\/2015\/09\/2015-09-24_022613-300x94.png\" alt=\"2015-09-24_022613\" width=\"300\" height=\"94\" class=\"alignnone size-medium wp-image-2272\" srcset=\"https:\/\/tech.akat.info\/wp-content\/uploads\/2015\/09\/2015-09-24_022613-300x94.png 300w, https:\/\/tech.akat.info\/wp-content\/uploads\/2015\/09\/2015-09-24_022613-660x207.png 660w, https:\/\/tech.akat.info\/wp-content\/uploads\/2015\/09\/2015-09-24_022613.png 926w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<h1>\u53c2\u8003URL<\/h1>\n<p><a href=\"http:\/\/qiita.com\/ibara1454\/items\/40ce2d82926f48cf02bc\">Ubuntu\u3067PostgreSQL\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u30ea\u30e2\u30fc\u30c8\u30a2\u30af\u30bb\u30b9\u307e\u3067\u306e\u624b\u9806<\/a><br \/>\n<a href=\"http:\/\/mogura.in\/blog\/2008\/11\/25\/postgresql-phppgadmin\">PostgreSQL phpPgAdmin\u304c\u52d5\u304b\u306a\u3044<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u63a5\u7d9a\u5143\u30b5\u30fc\u30d0\u8a2d\u5b9a phppgadmin\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u63a5\u7d9a\u5148\u30b5\u30fc\u30d0\u306e\u8a2d\u5b9a root@hostname:\/home\/shimizu# cat \/etc\/debian_version 8.2 root@hostname:\/h [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[88],"tags":[],"_links":{"self":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2271"}],"collection":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2271"}],"version-history":[{"count":1,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions"}],"predecessor-version":[{"id":2273,"href":"https:\/\/tech.akat.info\/index.php?rest_route=\/wp\/v2\/posts\/2271\/revisions\/2273"}],"wp:attachment":[{"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.akat.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}