{"id":14597,"date":"2024-03-25T13:23:14","date_gmt":"2024-03-25T04:23:14","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=14597"},"modified":"2024-03-25T13:40:05","modified_gmt":"2024-03-25T04:40:05","slug":"postgresql-%ec%82%ad%ec%a0%9c-on-centos","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=14597","title":{"rendered":"PostgreSQL \uc0ad\uc81c (on CentOS)"},"content":{"rendered":"<h3>\uba3c\uc800 postgresql\uc5d0 \ub300\ud55c \uc11c\ube44\uc2a4\ub97c \uc885\ub8cc\ud574\uc57c \ud568<\/h3>\n<p><code>systemctl stop postgresql<\/code><\/p>\n<p>\ub098 \uac19\uc740 \uacbd\uc6b0 \uc544\ub798\ucc98\ub7fc \ubc84\uc804\uc744 \uba85\ud655\ud788 \uba85\uc2dc\ud574\uc57c \ud588\uc74c<\/p>\n<p><code>systemctl stop postgresql-9.6<\/code><\/p>\n<h3>\ud328\uc9c0\ud0a4 \uc0ad\uc81c<\/h3>\n<p><code>sudo yum remove postgresql-server postgresql-contrib<\/code><\/p>\n<h3>DB\uac00 \uc800\uc7a5\ub41c \ub514\ub809\ud1a0\ub9ac \uc0ad\uc81c<\/h3>\n<p><code>sudo rm -rf \/var\/lib\/pgsql<\/code><\/p>\n<h3>postgres \uc0ac\uc6a9\uc790 \uc81c\uac70<\/h3>\n<p><code>userdel postgres<\/code><\/p>\n<h3>\ucd5c\uc2e0 \ubc84\uc804 \uc124\uce58\ub97c \uc704\ud55c yum \uc5c5\ub370\uc774\ud2b8<\/h3>\n<p>\uc77c\ub2e8 \ud604\uc7ac yum\uc5d0 \uc801\uc6a9\ub41c postgresql\uc758 \ubc84\uc804\uc744 \ud655\uc778<\/p>\n<p><code>yum info postgresql-server<\/code><\/p>\n<p>\uc124\uce58\ud558\uace0\uc790 \ud558\ub294 \ubc84\uc804\ubcf4\ub2e4 \ub0ae\uc744 \uacbd\uc6b0 \uc544\ub798 \uba85\ub839\uc744 \ud1b5\ud574 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \ubc18\uc601\ud568<\/p>\n<p><code>yum -y install https:\/\/download.postgresql.org\/pub\/repos\/yum\/reporpms\/EL-7-x86_64\/pgdg-redhat-repo-latest.noarch.rpm<br \/>\nyum repolist -y<br \/>\nyum -y update<\/code><\/p>\n<h3>\uc124\uce58<\/h3>\n<blockquote class=\"wp-embedded-content\" data-secret=\"GMwRum16dV\"><p><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=5087\">CentOS 7\uc5d0\uc11c PostgreSQL 10.2, PostGIS 2.4.3 \uc124\uce58(\uc778\ud130\ub137 \ud658\uacbd)<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;CentOS 7\uc5d0\uc11c PostgreSQL 10.2, PostGIS 2.4.3 \uc124\uce58(\uc778\ud130\ub137 \ud658\uacbd)&#8221; &#8212; GIS Developer\" src=\"http:\/\/www.gisdeveloper.co.kr\/?p=5087&#038;embed=true#?secret=VRCGXvIWnR#?secret=GMwRum16dV\" data-secret=\"GMwRum16dV\" width=\"525\" height=\"296\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uba3c\uc800 postgresql\uc5d0 \ub300\ud55c \uc11c\ube44\uc2a4\ub97c \uc885\ub8cc\ud574\uc57c \ud568 systemctl stop postgresql \ub098 \uac19\uc740 \uacbd\uc6b0 \uc544\ub798\ucc98\ub7fc \ubc84\uc804\uc744 \uba85\ud655\ud788 \uba85\uc2dc\ud574\uc57c \ud588\uc74c systemctl stop postgresql-9.6 \ud328\uc9c0\ud0a4 \uc0ad\uc81c sudo yum remove postgresql-server postgresql-contrib DB\uac00 \uc800\uc7a5\ub41c \ub514\ub809\ud1a0\ub9ac \uc0ad\uc81c sudo rm -rf \/var\/lib\/pgsql postgres \uc0ac\uc6a9\uc790 \uc81c\uac70 userdel postgres \ucd5c\uc2e0 \ubc84\uc804 \uc124\uce58\ub97c \uc704\ud55c yum \uc5c5\ub370\uc774\ud2b8 \uc77c\ub2e8 \ud604\uc7ac yum\uc5d0 \uc801\uc6a9\ub41c postgresql\uc758 \ubc84\uc804\uc744 \ud655\uc778 yum info &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=14597\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL \uc0ad\uc81c (on CentOS)&#8221;<\/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-14597","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\/14597","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=14597"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/14597\/revisions"}],"predecessor-version":[{"id":14603,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/14597\/revisions\/14603"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14597"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14597"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}