{"id":4748,"date":"2017-07-08T13:04:54","date_gmt":"2017-07-08T04:04:54","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=4748"},"modified":"2017-07-08T21:21:16","modified_gmt":"2017-07-08T12:21:16","slug":"centos-7%ec%97%90%ec%84%9c-postgresql-9-6-2-postgis-2-3-2-1-%ec%84%a4%ec%b9%98%ec%9d%b8%ed%84%b0%eb%84%b7-%ed%99%98%ea%b2%bd","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=4748","title":{"rendered":"CentOS 7\uc5d0\uc11c Postgresql 9.6.2, Postgis 2.3.2-1 \uc124\uce58(\uc778\ud130\ub137 \ud658\uacbd)"},"content":{"rendered":"

\uc778\ud130\ub137\uc774 \ub418\ub294 \ud658\uacbd\uc5d0\uc11c PostgreSQL(9.6.2)\uc640 PostGIS(2.3.2)\ub97c \uc124\uce58\ud558\ub294 \uc808\ucc28\uc785\ub2c8\ub2e4.<\/p>\n

PostgreSQL 9.6.2 \uc124\uce58<\/h4>\n

1. PostgreSQL\uacfc PostGIS \uc124\uce58\ub97c \uc704\ud55c yum \uc800\uc7a5\uc18c \uc5c5\ub370\uc774\ud2b8<\/p>\n

rpm -Uvh https:\/\/yum.postgresql.org\/9.6\/redhat\/rhel-7-x86_64\/pgdg-centos96-9.6-3.noarch.rpm<\/code><\/p>\n

2. PostgreSQL \uc124\uce58<\/p>\n

yum install postgresql96-server postgresql96<\/code><\/p>\n

3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5\uc18c \uc0dd\uc131<\/p>\n

.\/postgresql96-setup initdb<\/code><\/p>\n

4. PostgreSQL \uc11c\ube44\uc2a4 \uc2e4\ud589<\/p>\n

systemctl enable postgresql-9.6
\nsystemctl enable postgresql-9.6.service
\nsystemctl start postgresql-9.6.service<\/code><\/p>\n

5. \ubc29\ud654\ubcbd\uc5d0\uc11c port 5432\ubc88 \uac1c\ubc29<\/p>\n

firewall-cmd --zone=public --add-port=5432\/tcp<\/code><\/p>\n

6. \uc678\ubd80\uc5d0\uc11c DBMS \uc811\uadfc \ud5c8\uc6a9 \uc124\uc815<\/p>\n

vi postgresql.conf<\/code><\/p>\n

\uc544\ub798\ucc98\ub7fc \ud3b8\uc9d1<\/p>\n

listen_addresses = \"*\"<\/code><\/p>\n

7. postgres \uc0ac\uc6a9\uc790 \uc554\ud638 \uc124\uc815<\/p>\n

su - postgres
\n psql
\n \\password postgres
\n \\q<\/code><\/p>\n

8. \uc774\uc804 \uc0ac\uc6a9\uc790\ub85c \ubcf5\uadc0
\nsu - root<\/code><\/p>\n

9. \uc678\ubd80 \uc811\uc18d\uc744 \uc704\ud55c \ubcf4\uc548\uc124\uc815 \ubcc0\uacbd<\/p>\n

vi pg_hba.conf<\/code><\/p>\n

\uc544\ub798\ucc98\ub7fc \ud3b8\uc9d1<\/p>\n

local all all peer \ubb38\uc790\uc5f4\uc744 local all all md5 \ub85c \ubcc0\uacbd
\nhost all all 127.0.0.1\/32 ident \ubb38\uc790\uc5f4\uc744 host all all 0.0.0.0\/0 md5 \ub85c \ubcc0\uacbd
\nhost all all ::1\/128 ident \ubb38\uc790\uc5f4\uc744 host all all ::1\/128 md5 \ub85c \ubcc0\uacbd
\n<\/code><\/p>\n

10. PostgreSQL \uc11c\ube44\uc2a4 \uc7ac\uae30\ub3d9<\/p>\n

systemctl stop postgresql-9.6.service
\nsystemctl start postgresql-9.6.service<\/code><\/p>\n

11. [2017-07-08 \ucd94\uac00] UUID \ud655\uc7a5 \uae30\ub2a5 \uc124\uce58\ub97c \uc704\ud574 \ub2e4\uc74c \uba85\ub839\uc774 \ud544\uc694\ud568<\/p>\n

systemctl stop postgresql-9.6.service
\nyum install postgresql96-contrib.x86_64
\nsystemctl start postgresql-9.6.service
\n<\/code> <\/p>\n

PostGIS \uc124\uce58<\/h4>\n

yum install epel-release
\nyum install postgis2_96.x86_64
\nsystemctl restart postgresql-9.6.service<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

\uc778\ud130\ub137\uc774 \ub418\ub294 \ud658\uacbd\uc5d0\uc11c PostgreSQL(9.6.2)\uc640 PostGIS(2.3.2)\ub97c \uc124\uce58\ud558\ub294 \uc808\ucc28\uc785\ub2c8\ub2e4. PostgreSQL 9.6.2 \uc124\uce58 1. PostgreSQL\uacfc PostGIS \uc124\uce58\ub97c \uc704\ud55c yum \uc800\uc7a5\uc18c \uc5c5\ub370\uc774\ud2b8 rpm -Uvh https:\/\/yum.postgresql.org\/9.6\/redhat\/rhel-7-x86_64\/pgdg-centos96-9.6-3.noarch.rpm 2. PostgreSQL \uc124\uce58 yum install postgresql96-server postgresql96 3. \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5\uc18c \uc0dd\uc131 .\/postgresql96-setup initdb 4. PostgreSQL \uc11c\ube44\uc2a4 \uc2e4\ud589 systemctl enable postgresql-9.6 systemctl enable postgresql-9.6.service systemctl start postgresql-9.6.service 5. \ubc29\ud654\ubcbd\uc5d0\uc11c port 5432\ubc88 \uac1c\ubc29 firewall-cmd –zone=public –add-port=5432\/tcp … <\/p>\n

\ub354 \ubcf4\uae30 “CentOS 7\uc5d0\uc11c Postgresql 9.6.2, Postgis 2.3.2-1 \uc124\uce58(\uc778\ud130\ub137 \ud658\uacbd)”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4748","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4748","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4748"}],"version-history":[{"count":8,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4748\/revisions"}],"predecessor-version":[{"id":4856,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4748\/revisions\/4856"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4748"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4748"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4748"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}