{"id":8279,"date":"2019-10-15T13:27:09","date_gmt":"2019-10-15T04:27:09","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=8279"},"modified":"2020-05-28T10:11:03","modified_gmt":"2020-05-28T01:11:03","slug":"psql%ec%9d%84-%ec%84%a4%ec%b9%98%eb%90%9c-%ec%84%9c%eb%b2%84%ec%97%90%ec%84%9c-%ec%a7%81%ec%a0%91-%ec%8b%a4%ed%96%89%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=8279","title":{"rendered":"psql\uc744 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0\uc11c \uc9c1\uc811 \uc2e4\ud589\ud558\uae30"},"content":{"rendered":"

PostgreSQL\uc5d0 \ub300\ud55c \ucf58\uc194 \uad00\ub9ac\uc790\ub294 psql\uc785\ub2c8\ub2e4. \ud604\uc7ac CentOS\uc5d0\uc11c \uc124\uce58\ud574 \uc0ac\uc6a9\uc911\uc774\uace0, DB \uc791\uc5c5\uc2dc\uc5d0\ub294 Telnet\uc744 \ud1b5\ud574 \uc791\uc5c5\uc744 \ud574\uc654\ub294\ub370, \uc2dc\uac04\uc744 \ub2e8\ucd95\ud558\uace0\uc790 \uc6d0\uaca9\ubc29\uc2dd\uc774 \uc544\ub2cc \uc9c1\uc811 \uc11c\ubc84\ub2e8\uc5d0\uc11c \uc791\uc5c5\uc744 \ud588\uc2b5\ub2c8\ub2e4. \uc6d0\uaca9 \uc791\uc5c5\uc2dc \uc900\ube44\ub41c SQL\uc5d0 \ub300\ud55c \ucc98\ub9ac\uc5d0\ub9cc 2\uc77c\uc815\ub3c4 \uc18c\uc694\ub418\ub294 \uc791\uc5c5\uc774 10\uc2dc\uac04\uc815\ub3c4 \uc18c\uc694\ub418\uc5c8\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774 \uae00\uc740 \ucd94\ud6c4 PostgreSQL\uc774 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0\uc11c \uc9c1\uc811 psql\uc744 \uc2e4\ud589\ud558\uace0\uc790 \ud560\ub54c \uc785\ub825\ud588\ub358 \ucf58\uc194 \uba85\ub839\uc744 \uae30\ub85d\ud574 \ub461\ub2c8\ub2e4.<\/p>\n

\uba3c\uc800 \uc544\ub798\ucc98\ub7fc root\ub85c \ub85c\uadf8\uc778\ud55c \uc0c1\ud0dc\uc5d0\uc11c postgres \uacc4\uc815\uc73c\ub85c \uc804\ud658\ud569\ub2c8\ub2e4.<\/p>\n

\r\nsudo -i -u postgres\r\n<\/pre>\n
\uadf8\ub9ac\uace0 psql\uc744 \uc2e4\ud589\ud569\ub2c8\ub2e4. \ubc14\ub85c \uc554\ud638\ub97c \ubb3b\ub294\ub370 postgres \uacc4\uc815\uc5d0 \ub300\ud55c \uc554\ud638\ub97c \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n
\uae30\ubcf8\uc801\uc73c\ub85c psql\uc740 postgres\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ub429\ub2c8\ub2e4. \uc774\ub97c \ub0b4\uac00 \uc6d0\ud558\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub85c \uc5f0\uacb0\ud558\uace0\uc790\ud560 \ub54c \uc544\ub798\ucc98\ub7fc \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n
\r\n\\c database_name_to_be_connected\r\n<\/pre>\n
\ud544\uc694\ud558\ub2e4\uba74, SQL \ubb38\uc758 \uc778\ucf54\ub529 \ubc29\uc2dd\uc744 \ubcc0\uacbd\ud574\uc918\uc57c \ud558\ub294\ub370\uc694. \uc544\ub798\ucc98\ub7fc \uc785\ub825\ud558\uc5ec \uc6d0\ud558\ub294 \ubc29\uc2dd\uc73c\ub85c \ubcc0\uacbd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\r\nset client_encoding = 'UTF8';\r\n<\/pre>\n
\uc774\uc81c \uc900\ube44\ub41c SQL\ubb38\uc774 \uc800\uc7a5\ub41c \ud30c\uc77c\ub85c\ubd80\ud130 SQL \ubb38\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud574 \uc544\ub798\ucc98\ub7fc \uc785\ub825\ud569\ub2c8\ub2e4.<\/p>\n
\r\n\\i \/somewhere_dir\/file_name_to_be_ran\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
PostgreSQL\uc5d0 \ub300\ud55c \ucf58\uc194 \uad00\ub9ac\uc790\ub294 psql\uc785\ub2c8\ub2e4. \ud604\uc7ac CentOS\uc5d0\uc11c \uc124\uce58\ud574 \uc0ac\uc6a9\uc911\uc774\uace0, DB \uc791\uc5c5\uc2dc\uc5d0\ub294 Telnet\uc744 \ud1b5\ud574 \uc791\uc5c5\uc744 \ud574\uc654\ub294\ub370, \uc2dc\uac04\uc744 \ub2e8\ucd95\ud558\uace0\uc790 \uc6d0\uaca9\ubc29\uc2dd\uc774 \uc544\ub2cc \uc9c1\uc811 \uc11c\ubc84\ub2e8\uc5d0\uc11c \uc791\uc5c5\uc744 \ud588\uc2b5\ub2c8\ub2e4. \uc6d0\uaca9 \uc791\uc5c5\uc2dc \uc900\ube44\ub41c SQL\uc5d0 \ub300\ud55c \ucc98\ub9ac\uc5d0\ub9cc 2\uc77c\uc815\ub3c4 \uc18c\uc694\ub418\ub294 \uc791\uc5c5\uc774 10\uc2dc\uac04\uc815\ub3c4 \uc18c\uc694\ub418\uc5c8\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc740 \ucd94\ud6c4 PostgreSQL\uc774 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0\uc11c \uc9c1\uc811 psql\uc744 \uc2e4\ud589\ud558\uace0\uc790 \ud560\ub54c \uc785\ub825\ud588\ub358 \ucf58\uc194 \uba85\ub839\uc744 \uae30\ub85d\ud574 \ub461\ub2c8\ub2e4. \uba3c\uc800 \uc544\ub798\ucc98\ub7fc root\ub85c \ub85c\uadf8\uc778\ud55c \uc0c1\ud0dc\uc5d0\uc11c postgres … <\/p>\n
\ub354 \ubcf4\uae30 “psql\uc744 \uc124\uce58\ub41c \uc11c\ubc84\uc5d0\uc11c \uc9c1\uc811 \uc2e4\ud589\ud558\uae30”<\/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":[7],"tags":[],"class_list":["post-8279","post","type-post","status-publish","format-standard","hentry","category-gis-working-history"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8279","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=8279"}],"version-history":[{"count":3,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8279\/revisions"}],"predecessor-version":[{"id":9373,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/8279\/revisions\/9373"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8279"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8279"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8279"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}