{"id":94,"date":"2006-06-12T11:14:59","date_gmt":"2006-06-12T02:14:59","guid":{"rendered":"http:\/\/www.kaz.bz\/wp\/archives\/47"},"modified":"2006-06-12T11:14:59","modified_gmt":"2006-06-12T02:14:59","slug":"postgresql-%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88","status":"publish","type":"post","link":"https:\/\/wp.kaz.bz\/tech\/2006\/06\/12\/94.html","title":{"rendered":"PostgreSQL \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b9\u30af\u30ea\u30d7\u30c8"},"content":{"rendered":"<p>#! \/bin\/sh<\/p>\n<p>PGSQL_VER=postgresql-7.4.6<br \/>\nPGSQL_DIR=\/usr\/local\/pgsql<br \/>\nBASH_PROFILE=.bash_profile<br \/>\nmkdir -p $PGSQL_DIR<br \/>\nuseradd -d $PGSQL_DIR postgres<\/p>\n<p>tar zxvf $PGSQL_VER.tar.gz<br \/>\ncd $PGSQL_VER<\/p>\n<p>.\/configure \\<br \/>\n&#160;&#160;&#160; --enable-multibyte=EUC_JP \\<br \/>\n&#160;&#160;&#160; --with-openssl=\/usr\/local\/ssl<\/p>\n<p>make all<br \/>\nmake install<br \/>\ncd ~postgres<\/p>\n<p>cat >>&#160;$BASH_PROFILE < < EOF&#160;\n\n#==========================\n# PostgreSQL Configuration\n#==========================\nPATH=\\$PATH:\\$HOME\/bin:$PGSQL_DIR\/bin\nexport POSTGRES_HOME=$PGSQL_DIR\nexport PGDATA=$PGSQL_DIR\/data\nexport PGLIB=$PGSQL_DIR\/lib\nexport LD_LIBRARY_PATH=$PGSQL_DIR\/lib\n\nEOF\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>#! \/bin\/sh PGSQL_VER=postgresql-7.4.6 PGSQL_DIR=\/usr\/local\/pgsql BASH_PROFILE=.bash_profile mkdir -p $PGSQL_DI [&hellip;]<\/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-94","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":634,"url":"https:\/\/wp.kaz.bz\/tech\/2011\/02\/03\/634.html","url_meta":{"origin":94,"position":0},"title":"daemontools + ucspi-tcp + djbdns(dnscache) + netqmail =","author":"kaz. Suenaga","date":"2011\/02\/03","format":false,"excerpt":"\u4e00\u6c17\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u6c7a\u3081\u3046\u3061\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u3059\u3002 \/usr\/local\/src\/djb \u3068\u304b\u306b ins\u2026","rel":"","context":"DJB","block_context":{"text":"DJB","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":42,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/06\/11\/42.html","url_meta":{"origin":94,"position":1},"title":"PHP5\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306econfigure\u30aa\u30d7\u30b7\u30e7\u30f3\u4f8b\u3002","author":"kaz. Suenaga","date":"2008\/06\/11","format":false,"excerpt":"OpenSSL\u3001MySQL\u3001PostgreSQL\u306a\u3069\u306f\u30bd\u30fc\u30b9\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u308b\u524d\u63d0\u3067\u3059\u3002 .\/\u2026","rel":"","context":"PHP","block_context":{"text":"PHP","link":"https:\/\/wp.kaz.bz\/tech\/category\/langs\/php"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/12\/02\/28.html","url_meta":{"origin":94,"position":2},"title":"list_members\u3067\u6587\u5b57\u5316\u3051\u56de\u907f\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3002","author":"kaz. Suenaga","date":"2008\/12\/02","format":false,"excerpt":"python\u306e\u8a2d\u5b9a\u3092\u5909\u66f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\u3089\u3057\u3044\u3002 http:\/\/www.python.jp\/piper\u2026","rel":"","context":"mailman","block_context":{"text":"mailman","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/mailman"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/03\/11\/24.html","url_meta":{"origin":94,"position":3},"title":"ONE\/DEPO\u3092\u5229\u7528\u3059\u308b\u969b\u306b\u4f7f\u3063\u305fPHP\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306econfigure\u30aa\u30d7\u30b7\u30e7\u30f3","author":"kaz. Suenaga","date":"2009\/03\/11","format":false,"excerpt":"\u4f59\u8a08\u306a\u3082\u306e\u3082\u3042\u308b\u306f\u305a\u3067\u3059\u304c\u3001\u3068\u308a\u3042\u3048\u305a\u52d5\u3044\u305fconfigure\u30aa\u30d7\u30b7\u30e7\u30f3\u3067\u3059\u3002 \u304a\u305d\u3089\u304fPDO\u7cfb\u306f\u4e0d\u2026","rel":"","context":"ONE\/DEPO","block_context":{"text":"ONE\/DEPO","link":"https:\/\/wp.kaz.bz\/tech\/category\/web\/onedepo"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":47,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/03\/14\/47.html","url_meta":{"origin":94,"position":4},"title":"daemontools+ucspi-tcp with netqmail \u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u3002","author":"kaz. Suenaga","date":"2008\/03\/14","format":false,"excerpt":"daemontools\u3068ucspi-tcp\u3092\u3001netqmail\u306e\u30d1\u30c3\u30c1\u3092\u5229\u7528\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u30b9\u30af\u2026","rel":"","context":"DJB","block_context":{"text":"DJB","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":48,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/03\/14\/48.html","url_meta":{"origin":94,"position":5},"title":"daemontools\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b9\u30af\u30ea\u30d7\u30c8","author":"kaz. Suenaga","date":"2008\/03\/14","format":false,"excerpt":"#! \/bin\/sh PACK=daemontools-0.76 create_package_di\u2026","rel":"","context":"DJB","block_context":{"text":"DJB","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/94","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=94"}],"version-history":[{"count":0,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/94\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/media?parent=94"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/categories?post=94"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/tags?post=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}