{"id":428,"date":"2005-01-13T22:53:38","date_gmt":"2005-01-13T13:53:38","guid":{"rendered":"http:\/\/153.126.194.20\/?p=428"},"modified":"2024-11-17T15:23:39","modified_gmt":"2024-11-17T06:23:39","slug":"vine-postgresql","status":"publish","type":"post","link":"https:\/\/funaori.com\/ja\/2005\/01\/13\/vine-postgresql\/","title":{"rendered":"vine\/Postgresql"},"content":{"rendered":"<h2 id=\"content_1_0\">PostgreSQL\u306e\u8a2d\u5b9a\u30e1\u30e2  <a class=\"anchor_super\" id=\"n65c62a7\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#n65c62a7\" title=\"n65c62a7\">\u2020<\/a><\/h2>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_1\">\/var\/lib\/pgsql\/data\/postgresql.conf\u306e\u8a2d\u5b9a  <a class=\"anchor_super\" id=\"g8c67a58\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#g8c67a58\" title=\"g8c67a58\">\u2020<\/a><\/h3>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b<\/li>\n<\/ul>\n<pre>tcpip_socket = true<\/pre>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>Port\u8a2d\u5b9a<\/li>\n<\/ul>\n<pre>port = 5432<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_2\">\/var\/lib\/pgsql\/data\/pg_hba.conf\u306e\u8a2d\u5b9a  <a class=\"anchor_super\" id=\"gcde6428\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#gcde6428\" title=\"gcde6428\">\u2020<\/a><\/h3>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30a2\u30af\u30bb\u30b9\u5236\u9650<\/li>\n<\/ul>\n<pre>host    all         all         127.0.0.1         255.255.255.255   trust<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h2 id=\"content_1_3\">\u64cd\u4f5c\u30e1\u30e2  <a class=\"anchor_super\" id=\"v066d144\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#v066d144\" title=\"v066d144\">\u2020<\/a><\/h2>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_4\">\u521d\u671f\u8a2d\u5b9a  <a class=\"anchor_super\" id=\"j8449c77\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#j8449c77\" title=\"j8449c77\">\u2020<\/a><\/h3>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30e6\u30fc\u30b6\u306e\u4f5c\u6210<\/li>\n<\/ul>\n<pre>$ createuser hoge<\/pre>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/li>\n<\/ul>\n<pre>$ createdb SampleDB<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_5\">Apache\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b\uff0e  <a class=\"anchor_super\" id=\"b35dea13\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#b35dea13\" title=\"b35dea13\">\u2020<\/a><\/h3>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>Apach\u30e6\u30fc\u30b6\u306e\u8ffd\u52a0<\/li>\n<\/ul>\n<pre>$ createuser apache<\/pre>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>Apache\u30e6\u30fc\u30b6\u306b\u6a29\u9650\u3092\u4e0e\u3048\u308b<\/li>\n<\/ul>\n<pre>$ psql -n SampleDB\r\nSampleDB=&gt; grant all on SampleTable to apache;<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_6\">\u899a\u66f8  <a class=\"anchor_super\" id=\"tc8b8920\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#tc8b8920\" title=\"tc8b8920\">\u2020<\/a><\/h3>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4e00\u89a7\u8868\u793a<\/li>\n<\/ul>\n<pre>$ psql -l<\/pre>\n<ul class=\"list1\" style=\"padding-left:16px;margin-left:16px\">\n<li>\u30c6\u30fc\u30d6\u30eb\u306e\u4e00\u89a7\u8868\u793a<\/li>\n<\/ul>\n<pre>=&gt; \\dt<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h2 id=\"content_1_7\">Ruby\u306eDB\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  <a class=\"anchor_super\" id=\"qec2ce94\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#qec2ce94\" title=\"qec2ce94\">\u2020<\/a><\/h2>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_8\">Ruby\/PostgreSQL\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  <a class=\"anchor_super\" id=\"t3b8c2a9\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#t3b8c2a9\" title=\"t3b8c2a9\">\u2020<\/a><\/h3>\n<p><a href=\"http:\/\/www.postgresql.jp\/interfaces\/ruby\/index-ja.html\" rel=\"nofollow\">\u53c2\u8003\u30da\u30fc\u30b8<\/a><\/p>\n<pre>$ tar zxvf ruby-postgres-0.7.1.tar.gz\r\n$ cd ruby-postgres-0.7.1\r\n$ ruby  extconf.rb  --with-pgsql-include-dir=\/usr\/include\/pgsql\/ --with-pgsql-lib-dir=\/usr\/lib\/pgsql\/\r\n$ make\r\n$ su\r\n# make install<\/pre>\n<div class=\"jumpmenu\"><a href=\"#navigator\">\u2191<\/a><\/div>\n<h3 id=\"content_1_9\">Ruby\/DBI\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb  <a class=\"anchor_super\" id=\"da6ab85b\" href=\"http:\/\/192.168.1.4\/www_old\/linux\/index.php?vine%2FPostgresql#da6ab85b\" title=\"da6ab85b\">\u2020<\/a><\/h3>\n<p><a href=\"http:\/\/ruby-dbi.sourceforge.net\/\" rel=\"nofollow\">\u53c2\u8003\u30da\u30fc\u30b8<\/a><\/p>\n<pre>$ tar zxvf ruby-dbi-all-0.0.21.tar.gz\r\n$ cd ruby-dbi-all\r\n $ ruby setup.rb config --with=dbi,dbd_pg,dbd_mysql\r\n $ ruby setup.rb setup\r\n $ su\r\n # ruby setup.rb install<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\u306e\u8a2d\u5b9a\u30e1\u30e2 \u2020 \u2191 \/var\/lib\/pgsql\/data\/postgresql.conf\u306e\u8a2d\u5b9a \u2020 \u30cd\u30c3\u30c8\u30ef\u30fc\u30af\u304b\u3089\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3088\u3046\u306b\u3059\u308b tcpip_socket = true Port\u8a2d\u5b9a p&hellip; <a class=\"more-link\" href=\"https:\/\/funaori.com\/ja\/2005\/01\/13\/vine-postgresql\/\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">vine\/Postgresql<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"428","footnotes":""},"categories":[15],"tags":[],"class_list":["post-428","post","type-post","status-publish","format-standard","hentry","category-vine","ja","entry"],"_links":{"self":[{"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/posts\/428","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/comments?post=428"}],"version-history":[{"count":1,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/posts\/428\/revisions"}],"predecessor-version":[{"id":429,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/posts\/428\/revisions\/429"}],"wp:attachment":[{"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/media?parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/categories?post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/funaori.com\/wp-json\/wp\/v2\/tags?post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}