{"id":14317,"date":"2023-12-29T15:34:14","date_gmt":"2023-12-29T06:34:14","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=14317"},"modified":"2024-02-19T12:43:47","modified_gmt":"2024-02-19T03:43:47","slug":"postgresql-%ed%85%8c%ec%9d%b4%eb%b8%94%ec%8a%a4%ed%8e%98%ec%9d%b4%ec%8a%a4-%ec%83%9d%ec%84%b1","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=14317","title":{"rendered":"postgreSQL \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131"},"content":{"rendered":"

DB \uc6a9\ub7c9\uc774 \ub298\uc5b4\ub098\uac8c \ub418\uba74 \ubb3c\ub9ac\uc801\uc778 \uc800\uc7a5\uc7a5\uce58\ub97c \ubd84\ub9ac\ud574\uc11c DB\ub97c \ub098\ub220 \uc800\uc7a5\ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae30\uac8c \ub418\ub294\ub370 \uc774\ub54c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4(Table Space)\ub77c\ub294 \ub2e8\uc704\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ucc38\uace0\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub294 \uc624\ub77c\ud074\uc774\ub098 \ud3ec\uc2a4\ud2b8\uadf8\ub798\uc2a4\ud050\uc5d8 \ub4f1\uacfc \uac19\uc740 \uc5d4\ud130\ud504\ub77c\uc774\uc988 DBMS\uc5d0\uc11c\ub9cc \uc9c0\uc6d0\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4.<\/p>\n

\uba3c\uc800 \uc800\uc7a5\uc7a5\uce58\uc758 \uc6a9\ub7c9\uc744 \ud655\uc778\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

df -h<\/code><\/p>\n

\uadf8\ub9ac\uace0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub85c \uc0ac\uc6a9\ud560 \ub514\ub809\ud1a0\ub9ac\ub97c \uc0dd\uc131\ud574\uc57c \ud558\uad6c\uc694.<\/p>\n

mkdir pg_tablespace_geocode2
\nchown postgres pg_tablespace_geocode2<\/code><\/p>\n

psql\uc744 \ud1b5\ud574 \ub2e4\uc74c\ucc98\ub7fc \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \uc0dd\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ucc38\uace0\ub85c psql\uc744 \uc2e4\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 postgres \uc0ac\uc6a9\uc790\uc758 \uad8c\ud55c\uc744 \ud544\uc694\ud558\uba70 su – postgres\uc640 \uac19\uc740 \uba85\ub839\uc774 \ud544\uc694\ud569\ub2c8\ub2e4.<\/p>\n

create tablespace ts_geocode2 location '\/usr\/GeoService-Xr\/webHome\/user-files\/pg_tablespace_geocode2';<\/code><\/p>\n

\ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c \ud655\uc778\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

\\db<\/code><\/p>\n

\ud2b9\uc815 \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\uc5d0 DB\ub97c \uc0dd\uc131\ud558\ub294 \uba85\ub839\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

CREATE DATABASE gis_20240219 WITH TABLESPACE = ts_geocode2;<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

DB \uc6a9\ub7c9\uc774 \ub298\uc5b4\ub098\uac8c \ub418\uba74 \ubb3c\ub9ac\uc801\uc778 \uc800\uc7a5\uc7a5\uce58\ub97c \ubd84\ub9ac\ud574\uc11c DB\ub97c \ub098\ub220 \uc800\uc7a5\ud558\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae30\uac8c \ub418\ub294\ub370 \uc774\ub54c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4(Table Space)\ub77c\ub294 \ub2e8\uc704\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. \ucc38\uace0\ub85c \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub294 \uc624\ub77c\ud074\uc774\ub098 \ud3ec\uc2a4\ud2b8\uadf8\ub798\uc2a4\ud050\uc5d8 \ub4f1\uacfc \uac19\uc740 \uc5d4\ud130\ud504\ub77c\uc774\uc988 DBMS\uc5d0\uc11c\ub9cc \uc9c0\uc6d0\ud558\ub294 \uacbd\uc6b0\uac00 \ub9ce\uc2b5\ub2c8\ub2e4. \uba3c\uc800 \uc800\uc7a5\uc7a5\uce58\uc758 \uc6a9\ub7c9\uc744 \ud655\uc778\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. df -h \uadf8\ub9ac\uace0 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub85c \uc0ac\uc6a9\ud560 \ub514\ub809\ud1a0\ub9ac\ub97c \uc0dd\uc131\ud574\uc57c \ud558\uad6c\uc694. mkdir pg_tablespace_geocode2 chown postgres pg_tablespace_geocode2 psql\uc744 \ud1b5\ud574 \ub2e4\uc74c\ucc98\ub7fc \ud14c\uc774\ube14 \uc2a4\ud398\uc774\uc2a4\ub97c … <\/p>\n

\ub354 \ubcf4\uae30 “postgreSQL \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc0dd\uc131”<\/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-14317","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\/14317","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=14317"}],"version-history":[{"count":6,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/14317\/revisions"}],"predecessor-version":[{"id":14320,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/14317\/revisions\/14320"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}