{"id":19,"date":"2015-11-12T17:24:45","date_gmt":"2015-11-12T09:24:45","guid":{"rendered":"https:\/\/yanjingang.com\/blog\/?p=19"},"modified":"2015-11-12T17:24:45","modified_gmt":"2015-11-12T09:24:45","slug":"centos%e5%ae%89%e8%a3%85%e9%83%a8%e7%bd%b2postgresql","status":"publish","type":"post","link":"https:\/\/yanjingang.com\/blog\/?p=19","title":{"rendered":"Centos\u5b89\u88c5\u90e8\u7f72PostgreSQL"},"content":{"rendered":"

\u5b89\u88c5\uff1a<\/p>\n

wget https:\/\/ftp.postgresql.org\/pub\/source\/v9.4.4\/postgresql-9.4.4.tar.gz<\/a> –no-check-certificate<\/div>\n
tar -zxvf postgresql-9.4.4.tar.gz
\ncd postgresql-9.4.4<\/div>\n
.\/configure –prefix=\/home\/users\/yanjingang\/postgresql<\/div>\n
make<\/div>\n
make install<\/div>\n
<\/div>\n
\u542f\u52a8\uff1a<\/div>\n
cd \/home\/users\/yanjingang\/postgresql<\/div>\n
mkdir data<\/div>\n
.\/bin\/initdb -D\u00a0\/home\/users\/yanjingang\/postgresql\/data\/<\/div>\n
vim .\/data\/postgresql.conf \u00a0 \u00a0\u4fee\u6539data\u76ee\u5f55\u4e0b\u7684\u914d\u7f6e\u4fe1\u606f<\/div>\n
\/home\/users\/yanjingang\/postgresql\/bin\/pg_ctl -D\u00a0\/home\/users\/yanjingang\/postgresql\/data\/ -l logfile start \u00a0 \u00a0\u542f\u52a8\u5b9e\u4f8b<\/div>\n
.\/bin\/psql\u00a0postgres -p5433 \u9700\u8981\u6307\u5b9a\u7aef\u53e3\uff0c\u5426\u5219\u4f1a\u8fdb\u5165\u9ed8\u8ba4\u7aef\u53e3\u5b9e\u4f8b\u4e2d<\/div>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u5b89\u88c5\uff1a wget https:\/\/ftp.postgresql.org\/pub\/source\/v9.4.4\/p […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[17],"tags":[18,19],"_links":{"self":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/19"}],"collection":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=19"}],"version-history":[{"count":0,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/19\/revisions"}],"wp:attachment":[{"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yanjingang.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}