{"id":5087,"date":"2018-02-14T15:37:43","date_gmt":"2018-02-14T06:37:43","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=5087"},"modified":"2020-08-31T14:13:45","modified_gmt":"2020-08-31T05:13:45","slug":"centos-7%ec%97%90%ec%84%9c-postgresql-10-postgis-2-4-%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=5087","title":{"rendered":"CentOS 7\uc5d0\uc11c PostgreSQL 10.2, PostGIS 2.4.3 \uc124\uce58(\uc778\ud130\ub137 \ud658\uacbd)"},"content":{"rendered":"

\n# postgresql10, postgis YUM \uc800\uc7a5\uc18c \uc5c5\ub370\uc774\ud2b8<\/strong>
\nrpm -Uvh https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-centos10-10-2.noarch.rpm\n<\/p>\n

\uc704\uc758 url\uc740 \ubcc0\uacbd\ub420 \uc218 \uc788\uc73c\uba70 2020\ub144 8\uc6d4 31\uc77c\uc5d0\ub294 rpm -Uvh https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\ub85c \ud558\uc5ec \uc124\uce58\ub97c \uc9c4\ud589\ud588\uc73c\uba70, postgresql\uc740 10.10.14\ub97c, postgis\ub294 3.0.2\ub97c \uc124\uce58\ud558\uc600\uc74c.<\/p>\n

\n# \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58<\/strong>
\nyum install postgresql10-server.x86_64 postgresql10\n<\/p>\n

\n# \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5\uc18c \uc0dd\uc131<\/strong>
\ncd \/usr\/pgsql-10\/bin\/
\n.\/postgresql-10-setup initdb\n<\/p>\n

\n# \uc11c\ube44\uc2a4 \uc2e4\ud589<\/strong>
\nsystemctl enable postgresql-10
\nsystemctl enable postgresql-10.service
\nsystemctl start postgresql-10.service\n<\/p>\n

\n# 5432 \ud3ec\ud2b8 \ubc29\ud654\ubcbd \ud5c8\uc6a9<\/strong>
\nfirewall-cmd –zone=public –add-port=5432\/tcp\n<\/p>\n

\n# \uc678\ubd80 \uc811\uc18d \ud5c8\uc6a9<\/strong>
\ncd \/var\/lib\/pgsql\/10\/data
\nvi postgresql.conf
\n(\ud3b8\uc9d1 \ub0b4\uc6a9)
\nlisten_address = “*”\n<\/p>\n

\n# \uc554\ud638\uc124\uc815<\/strong>
\nsu – postgres
\npsql
\n\\password postgres
\n\\q
\nsu – root\n<\/p>\n

\n# \uc678\ubd80 \uc811\uc18d\uc744 \uc704\ud55c \ubcf4\uc548 \uc124\uc815<\/strong>
\ncd \/var\/lib\/pgsql\/10\/data
\nvi pg_hba.conf
\n(\ud3b8\uc9d1 \ub0b4\uc6a9)
\nlocal 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<\/p>\n

\n# PostGIS \uc124\uce58<\/strong>
\nyum install epel-release
\nyum install postgis24_10.x86_64
\nsystemctl restart postgresql-10.service<\/p>\n","protected":false},"excerpt":{"rendered":"

# postgresql10, postgis YUM \uc800\uc7a5\uc18c \uc5c5\ub370\uc774\ud2b8 rpm -Uvh https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-centos10-10-2.noarch.rpm \uc704\uc758 url\uc740 \ubcc0\uacbd\ub420 \uc218 \uc788\uc73c\uba70 2020\ub144 8\uc6d4 31\uc77c\uc5d0\ub294 rpm -Uvh https:\/\/download.postgresql.org\/pub\/repos\/yum\/10\/redhat\/rhel-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm\ub85c \ud558\uc5ec \uc124\uce58\ub97c \uc9c4\ud589\ud588\uc73c\uba70, postgresql\uc740 10.10.14\ub97c, postgis\ub294 3.0.2\ub97c \uc124\uce58\ud558\uc600\uc74c. # \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uce58 yum install postgresql10-server.x86_64 postgresql10 # \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc800\uc7a5\uc18c \uc0dd\uc131 cd \/usr\/pgsql-10\/bin\/ .\/postgresql-10-setup initdb # \uc11c\ube44\uc2a4 \uc2e4\ud589 systemctl enable postgresql-10 systemctl enable postgresql-10.service systemctl start postgresql-10.service … <\/p>\n

\ub354 \ubcf4\uae30 “CentOS 7\uc5d0\uc11c PostgreSQL 10.2, PostGIS 2.4.3 \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-5087","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\/5087","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=5087"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5087\/revisions"}],"predecessor-version":[{"id":12440,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/5087\/revisions\/12440"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5087"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}