{"id":4874,"date":"2018-10-24T10:42:49","date_gmt":"2018-10-24T01:42:49","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=4874"},"modified":"2024-04-29T15:56:42","modified_gmt":"2024-04-29T06:56:42","slug":"postgresql%ec%9d%98-%eb%8d%b0%ec%9d%b4%ed%84%b0-%eb%b0%b1%ec%97%85","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=4874","title":{"rendered":"PostgreSQL\uc758 \ub370\uc774\ud130 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0"},"content":{"rendered":"

# \ubc31\uc5c5<\/h2>\n

\uc544\ub798\uc758 \uba85\ub839\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uba85\uc774 gis\uc774\uba70 \ud14c\uc774\ube14 \uc911 ctprvn, sig, emd, road, li\ub97c \ub514\ub809\ud1a0\ub9ac \ud615\uc2dd(–foramt=d)\ub85c \ud558\uc5ec gis_db_dump\ub77c\ub294 \ud30c\uc77c\ub85c \ubc31\uc5c5\ud558\ub294 \uba85\ub839\uc785\ub2c8\ub2e4.<\/p>\n

pg_dump --dbname=gis --host=localhost --port=5432 --table=ctprvn --table=sig --table=emd --table=road --table=li --username=postgres --password --format=d --file=.\/gis_db_dump<\/code><\/p>\n

\ucc38\uace0\ub85c –table \uc635\uc158\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \uc9c0\uc815\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \ubc31\uc5c5\ud569\ub2c8\ub2e4.<\/p>\n

Windows\uc5d0\uc11c \uc77c\ubc18 text(sql \ud615\uc2dd)\uc73c\ub85c \ubc31\uc5c5 \ubc1b\ub294 \uacbd\uc6b0\uc758 \uba85\ub839\uc73c\ub85c \uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c cmd\ub97c \uc2e4\ud589\ud55c\ub2e4. \uc544\ub798\uc758 \uba85\ub839\uc5d0 \uc758\ud574 gis \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \ud14c\uc774\ube14\uc758 \ub370\uc774\ud130\ub97c db.sql \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc5b4 \ubc31\uc5c5\ub41c\ub2e4.<\/p>\n

pg_dump --dbname=gis --username=postgres --file=d:\/__Temp__\/db.sql<\/code><\/p>\n

# \ubcf5\uad6c<\/h2>\n

\ub610\ud55c \uc544\ub798\ub294 \uc704\uc5d0\uc11c \ubc31\uc5c5\ud55c \ub0b4\uc6a9\uc744 gis_20181022 \ub370\uc774\ud130 \ubca0\uc774\uc2a4\ub85c \ubcf5\uc6d0\uc2dc\ud0a4\ub294 \uba85\ub839\uc785\ub2c8\ub2e4.<\/p>\n

pg_restore --dbname=gis_20181022 --host=localhost --port=5432 --username=postgres --password --format=d .\/gis_db_dump<\/code><\/p>\n

\ub9ac\ub205\uc2a4\uc5d0\uc11c \uc2e4\ud589\ud558\uae30 \uc704\ud574\uc11c\ub294 su – postgres \ub97c \uc2e4\ud589\ud558\uc5ec \uad8c\ud55c\uc744 \uc5bb\uc744 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. pg_dump \uc2e4\ud589 \uc2dc –format\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc73c\ub85c \ub364\ud504 \ud30c\uc77c\uc774 \ub9cc\ub4e4\uc5b4\uc9c0\ub294\ub370 \uc774 \ub364\ud504 \ud30c\uc77c\uc740 pg_restore\ub97c \ud1b5\ud574 \ubcf5\uc6d0\ud558\uc9c0 \uc54a\uace0 psql\uc744 \ud1b5\ud574 \ubcf5\uc6d0\ud569\ub2c8\ub2e4. \uc989, psql\ub97c \uc2e4\ud589\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud558\uace0(\\c) \ub364\ud504 \ud30c\uc77c\uc744 \uc2e4\ud589(\\i) \ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

# \ubc31\uc5c5 \uc544\ub798\uc758 \uba85\ub839\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uba85\uc774 gis\uc774\uba70 \ud14c\uc774\ube14 \uc911 ctprvn, sig, emd, road, li\ub97c \ub514\ub809\ud1a0\ub9ac \ud615\uc2dd(–foramt=d)\ub85c \ud558\uc5ec gis_db_dump\ub77c\ub294 \ud30c\uc77c\ub85c \ubc31\uc5c5\ud558\ub294 \uba85\ub839\uc785\ub2c8\ub2e4. pg_dump –dbname=gis –host=localhost –port=5432 –table=ctprvn –table=sig –table=emd –table=road –table=li –username=postgres –password –format=d –file=.\/gis_db_dump \ucc38\uace0\ub85c –table \uc635\uc158\uc744 \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \uc9c0\uc815\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\uccb4 \ud14c\uc774\ube14\uc744 \ubc31\uc5c5\ud569\ub2c8\ub2e4. Windows\uc5d0\uc11c \uc77c\ubc18 text(sql \ud615\uc2dd)\uc73c\ub85c \ubc31\uc5c5 \ubc1b\ub294 \uacbd\uc6b0\uc758 \uba85\ub839\uc73c\ub85c \uad00\ub9ac\uc790 \uad8c\ud55c\uc73c\ub85c cmd\ub97c … <\/p>\n

\ub354 \ubcf4\uae30 “PostgreSQL\uc758 \ub370\uc774\ud130 \ubc31\uc5c5 \ubc0f \ubcf5\uc6d0”<\/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":[44],"tags":[],"class_list":["post-4874","post","type-post","status-publish","format-standard","hentry","category-gis-tools"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4874","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=4874"}],"version-history":[{"count":10,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4874\/revisions"}],"predecessor-version":[{"id":5695,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4874\/revisions\/5695"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4874"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}