{"id":600,"date":"2024-11-15T16:31:04","date_gmt":"2024-11-15T16:31:04","guid":{"rendered":"https:\/\/realstudy.net\/?p=600"},"modified":"2024-11-16T11:13:25","modified_gmt":"2024-11-16T11:13:25","slug":"postgresql-db-%ec%83%9d%ec%84%b1-%eb%b0%b1%ec%97%85","status":"publish","type":"post","link":"https:\/\/realstudy.net\/?p=600&lang=ko","title":{"rendered":"PostgreSQL DB \uc0dd\uc131 &amp; \ubc31\uc5c5"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"600\" class=\"elementor elementor-600\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e5b556f e-flex e-con-boxed e-con e-parent\" data-id=\"e5b556f\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3720ac4 elementor-widget elementor-widget-text-editor\" data-id=\"3720ac4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>PostgreSQL\uc740 \uace0\uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uc790\ub791\ud558\uba70, \uc624\ud508 \uc18c\uc2a4\ub85c \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \uc774\ubc88 \uae00\uc5d0\uc11c\ub294 PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc0dd\uc131\ubd80\ud130 \ubc31\uc5c5\uae4c\uc9c0 \uc804\ubc18\uc801\uc778 \uacfc\uc815\uc744 \uc790\uc138\ud788 \uc124\uba85\ud569\ub2c8\ub2e4. \ud2b9\ud788, DBeaver\ub97c \ud65c\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131, \uad00\ub9ac \ubc0f \ucffc\ub9ac \uc2e4\ud589 \ubc29\ubc95\uc744 \ub2e4\ub8e8\uace0, pg_dump\ub97c \uc0ac\uc6a9\ud55c \ud6a8\uc728\uc801\uc778 \ubc31\uc5c5 \uc808\ucc28\ub97c \uc18c\uac1c\ud569\ub2c8\ub2e4. \ub610\ud55c Docker\uc640 Kubernetes\uc640 \uac19\uc740 \ucee8\ud14c\uc774\ub108 \ud658\uacbd\uc5d0\uc11c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ubc31\uc5c5\uc744 \uc5b4\ub5bb\uac8c \uc9c4\ud589\ud574\uc57c \ud558\ub294\uc9c0\uc5d0 \ub300\ud574 \uc2e4\uc6a9\uc801\uc778 \uc811\uadfc\ubc95\uc744 \uc81c\uc2dc\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \ub2e4\uc591\ud55c \ud658\uacbd\uc5d0\uc11c PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud6a8\uacfc\uc801\uc73c\ub85c \uad00\ub9ac\ud558\uace0 \ubcf4\ud638\ud558\ub294 \ubc29\ubc95\uc744 \uc774\ud574\ud560 \uc218 \uc788\uc744 \uac83\uc785\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f893b93 e-flex e-con-boxed e-con e-parent\" data-id=\"f893b93\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4c30dd2 elementor-widget elementor-widget-heading\" data-id=\"4c30dd2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* DBeaver \uc811\uc18d<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f181a88 elementor-widget elementor-widget-text-editor\" data-id=\"f181a88\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \uba3c\uc800 \uba54\ub274\uc5d0\uc11c &#8220;Database &gt; New Database Connection&#8221;\uc744 \uc120\ud0dd\ud558\uace0 DB\uc885\ub958\uc911 PostgreSQL\uc744 \uc120\ud0dd\ud569\ub2c8\ub2e4.<br \/>\u00a0 &gt; Host : db \uc11c\ubc84 \ub3c4\uba54\uc778 \ud639\uc740 IP<br \/>\u00a0 &gt; Port : \uc811\uc18d \ud3ec\ud2b8 (default : 5432)<br \/>\u00a0 &gt; Database : \ub370\uc774\ud130\ubca0\uc774\ud2b8 \uc774\ub984 (default : postgres)<br \/>\u00a0 &gt; Username \/ Password : \uc811\uc18d \uacc4\uc815 \uc815\ubcf4 (\uc124\uce58\uc2dc postgres \uacc4\uc815\uc5d0 \ub300\ud574 \uc124\uc815\ud55c \ube44\ubc00\ubc88\ud638)<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e1ccc39 elementor-widget elementor-widget-image\" data-id=\"e1ccc39\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"1021\" height=\"668\" src=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con1.jpg\" class=\"attachment-full size-full wp-image-615\" alt=\"\" srcset=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con1.jpg 1021w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con1-300x196.jpg 300w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con1-768x502.jpg 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6559249 elementor-widget elementor-widget-text-editor\" data-id=\"6559249\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* Test Connection : \uc785\ub825\ud55c \uc815\ubcf4\uace0 \uc815\uc0c1 \uc811\uc18d\uc774 \ub418\ub294\uc9c0 \ud655\uc778<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1290476 elementor-widget elementor-widget-image\" data-id=\"1290476\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1021\" height=\"668\" src=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con2.jpg\" class=\"attachment-full size-full wp-image-616\" alt=\"\" srcset=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con2.jpg 1021w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con2-300x196.jpg 300w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con2-768x502.jpg 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a14add6 elementor-widget elementor-widget-text-editor\" data-id=\"a14add6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \uba54\ub274\uc5d0\uc11c SQL Editor &gt; New SQL Script \uc120\ud0dd\ud558\uc5ec SQL \ucffc\ub9ac\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\ub294 script\ucc3d \ud65c\uc131\ud654<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f250b5 elementor-widget elementor-widget-image\" data-id=\"7f250b5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1021\" height=\"668\" src=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con3.jpg\" class=\"attachment-full size-full wp-image-621\" alt=\"\" srcset=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con3.jpg 1021w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con3-300x196.jpg 300w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con3-768x502.jpg 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-031c397 elementor-widget elementor-widget-text-editor\" data-id=\"031c397\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* SQL \ud3b8\uc9d1\uae30\uc5d0 \ucffc\ub9ac \uc791\uc131\ud6c4 &#8220;Control + Enter&#8221; \ud0a4 \uc785\ub825<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-876f8ba elementor-widget elementor-widget-image\" data-id=\"876f8ba\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"1021\" height=\"668\" src=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con4.jpg\" class=\"attachment-full size-full wp-image-622\" alt=\"\" srcset=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con4.jpg 1021w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con4-300x196.jpg 300w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con4-768x502.jpg 768w\" sizes=\"(max-width: 1021px) 100vw, 1021px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-05c1fd1 e-flex e-con-boxed e-con e-parent\" data-id=\"05c1fd1\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-99d6237 elementor-widget elementor-widget-heading\" data-id=\"99d6237\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* DB \uc0dd\uc131 &amp; DB \uad00\ub9ac\uc790 USER \uc0dd\uc131<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f097bc elementor-widget elementor-widget-text-editor\" data-id=\"7f097bc\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \uc544\ub798 \uc608\uc81c\ub294\u001f test database\ub97c \ub9cc\ub4e4\uace0, \ub9cc\ub4e4\uc5b4\uc9c4 test database\ub97c \uad00\ub9ac\ud558\ub294 \uc288\ud37c\uad00\ub9ac\uc790\ub85c test_admin \uc720\uc800\ub97c \uc0dd\uc131\ud558\ub294 \ucffc\ub9ac \uc785\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-de3a147 elementor-widget elementor-widget-code-highlight\" data-id=\"de3a147\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>-- Create database\nCREATE DATABASE test;\n\n-- Create user\nCREATE USER test_admin WITH PASSWORD 'secure_password';\n\n-- Make a user the manager of a table\nALTER DATABASE test OWNER TO test_admin;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f682fd elementor-widget elementor-widget-text-editor\" data-id=\"4f682fd\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \ub9cc\uc57d \uc0ac\uc6a9\uc790\ub97c PostgreSQL \uc804\uccb4\ub97c \uad00\ub9ac\ud558\ub294 \uc288\ud37c\uc720\uc800\ub85c \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74 \uc544\ub798 \ucffc\ub9ac\ub97c \uc774\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. \ud558\uc9c0\ub9cc DB\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\uc790\ub97c \ub9cc\ub4e4\uace0 \uac1c\ubc1c \ubc0f \uad00\ub9ac\uc758 \ud3b8\uc758\uc131\uc744 \uc704\ud574 \uc288\ud37c\uc720\uc800\uad8c\ud55c\uc73c\ub85c \uc0c1\uc2b9 \uc2dc\ud0a4\ub294 \uac83\uc740 \ucd94\ucc9c\ud558\uc9c0 \uc54a\ub294 \ubc29\ubc95 \uc785\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7221ee8 elementor-widget elementor-widget-code-highlight\" data-id=\"7221ee8\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-sql line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-sql\">\n\t\t\t\t\t<xmp>ALTER USER test_admin WITH SUPERUSER;<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-127bd6d elementor-widget elementor-widget-text-editor\" data-id=\"127bd6d\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \uc0dd\uc131\ub41c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc774\uc6a9\ud558\uc5ec \ub2e4\uc2dc \uc811\uc18d\ud574 \ubcf4\uba74 \uc811\uc18d\uc774 \ub418\ub294 \uac83\uc744 \ud655\uc778 \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3a7c90d elementor-widget elementor-widget-image\" data-id=\"3a7c90d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"964\" height=\"635\" src=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con5.jpg\" class=\"attachment-full size-full wp-image-637\" alt=\"\" srcset=\"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con5.jpg 964w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con5-300x198.jpg 300w, https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/dbeaver_con5-768x506.jpg 768w\" sizes=\"(max-width: 964px) 100vw, 964px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a7e05e5 e-flex e-con-boxed e-con e-parent\" data-id=\"a7e05e5\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-619d9cb elementor-widget elementor-widget-heading\" data-id=\"619d9cb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* DB \ubc31\uc5c5<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-634c794 elementor-widget elementor-widget-text-editor\" data-id=\"634c794\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \ubc31\uc5c5\uc740 pg_dump\ub97c \uc774\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. \ub9cc\uc57d Local\uc5d0 PostgreSQL\uc744 \uc124\uce58 \ud588\ub2e4\uba74 Local shell\uc5d0\uc11c \uc544\ub798 \uba85\ub839\uc744 \ubc14\ub85c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-bece4c7 elementor-widget elementor-widget-code-highlight\" data-id=\"bece4c7\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp># pg_dump -U {user name} {db name} > {backup file name}\npostgres-user:~$ pg_dump -U test_admin test > backup.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-22b2f3a e-flex e-con-boxed e-con e-parent\" data-id=\"22b2f3a\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4c69f0d elementor-widget elementor-widget-heading\" data-id=\"4c69f0d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* Container\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 DB \ubc31\uc5c5<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-eaf7f20 elementor-widget elementor-widget-text-editor\" data-id=\"eaf7f20\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* PostgreSQL\uc774 \ucee8\ud14c\uc774\ub108\uc5d0\uc11c \uc2e4\ud589 \uc911\uc778 \uacbd\uc6b0, \uba3c\uc800 \ucee8\ud14c\uc774\ub108 \ub0b4\ubd80\uc758 \uc178\uc5d0 \uc811\uc18d\ud574\uc57c \ud569\ub2c8\ub2e4. \ubc31\uc5c5\uc744 \uc218\ud589\ud558\uba74 \ubc31\uc5c5 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc9c0\ub9cc, \uc77c\ubc18\uc801\uc73c\ub85c \ucee8\ud14c\uc774\ub108 \uc774\ubbf8\uc9c0\ub294 \ubcf4\uc548\uc0c1\uc758 \uc774\uc720\ub85c \uc811\uc18d \uc0ac\uc6a9\uc790\uc5d0\uac8c \uc81c\ud55c\ub41c \uad8c\ud55c\ub9cc \ubd80\uc5ec\ud569\ub2c8\ub2e4. \uc774\ub85c \uc778\ud574 \ud30c\uc77c\uc744 \uc0dd\uc131\ud560 \uc218 \uc5c6\ub294 \uc0c1\ud669\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574 \/tmp \ub514\ub809\ud1a0\ub9ac\ub85c \uc774\ub3d9\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc785\ub2c8\ub2e4. \uc774 \ub514\ub809\ud1a0\ub9ac\ub294 \uc77c\ubc18 \uc0ac\uc6a9\uc790\ub3c4 \ud30c\uc77c\uc744 \uc0dd\uc131\ud560 \uc218 \uc788\ub3c4\ub85d \ud5c8\uc6a9\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-be0cdfc elementor-widget elementor-widget-code-highlight\" data-id=\"be0cdfc\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp># Check the container id\nuser:~$ docker ps\nCONTAINER ID   IMAGE         COMMAND              CREATED         STATUS\nc3f279d17e0a   postgresq     \"\/bin\/bash\"        5 minutes ago   Up 5 minute\n\n# Enter the Container : docker exec -it <container_name_or_id> \/bin\/bash\nuser:~$ docker exec -it c3f279d17e0a \/bin\/bash\n\n# Change directory\nc3f279d17e0a:~$ cd \/tmp\n\n# DB backup : pg_dump -U {user name} {db name} > {backup file name}\nc3f279d17e0a:\/tmp$ pg_dump -U test_admin test > backup.sql\n\n# Exit from the Docker container to the local host\nc3f279d17e0a:\/tmp$ exit\nuser:~$ <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c2f06d2 elementor-widget elementor-widget-text-editor\" data-id=\"c2f06d2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \uc0dd\uc131\ub41c \ubc31\uc5c5 \ud30c\uc77c(backup.sql)\uc744 \ub85c\uceec\ub85c \uac00\uc838\uc624\uae30 \uc704\ud574 Docker \uba85\ub839\uc5b4\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub85c\uceec \ud638\uc2a4\ud2b8\ub85c \ubcf5\uc0ac\ud569\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-21cb46b elementor-widget elementor-widget-code-highlight\" data-id=\"21cb46b\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp># Copy the backup.sql file from the container to the local directory\nuser:~$ docker cp c3f279d17e0a:\/tmp\/backup.sql .<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-5baa19c e-flex e-con-boxed e-con e-parent\" data-id=\"5baa19c\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-68d9aa1 elementor-widget elementor-widget-heading\" data-id=\"68d9aa1\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* DB \ubcf5\uc6d0<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec6283b elementor-widget elementor-widget-text-editor\" data-id=\"ec6283b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div>* \ubcf5\uc6d0\uc740 psql\u001d\uc744 \uc774\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4. \ub9cc\uc57d Local\uc5d0 PostgreSQL\uc744 \uc124\uce58 \ud588\ub2e4\uba74 Localhost shell\uc5d0\uc11c \uc544\ub798 \uba85\ub839\uc744 \ubc14\ub85c \uc0ac\uc6a9\ud558\uba74 \ub429\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08535f1 elementor-widget elementor-widget-code-highlight\" data-id=\"08535f1\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp># psql -U {user name} {db name} < {backup file name}\npostgres-user:~$ psql -U test_admin test < backup.sql<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e0342a3 e-flex e-con-boxed e-con e-parent\" data-id=\"e0342a3\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-e4f5076 elementor-widget elementor-widget-heading\" data-id=\"e4f5076\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">* Container\uc5d0\uc11c \uc2e4\ud589\ub418\ub294 DB \ubcf5\uc6d0<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b13a2de elementor-widget elementor-widget-code-highlight\" data-id=\"b13a2de\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-tomorrow copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-bash line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-bash\">\n\t\t\t\t\t<xmp># Check the container id\nuser:~$ docker ps\nCONTAINER ID   IMAGE         COMMAND               CREATED         STATUS\nc3f279d17e0a   postgresq     \"\/bin\/bash\"        5 minutes ago   Up 5 minute\n\n# Copy the backup.sql file from the local directory to the container\nuser:~$ docker cp backup.sql c3f279d17e0a:\/tmp\n\n# Enter the Container : docker exec -it <container_name_or_id> \/bin\/bash\nuser:~$ docker exec -it c3f279d17e0a \/bin\/bash\n\n# Change directory\nc3f279d17e0a:~$ cd \/tmp\n\n# DB restore : psql -U {user name} {db name} < {backup file name}\nc3f279d17e0a:\/tmp$ psql -U test_admin test < backup.sql\n\n# Exit from the Docker container to the local host\nc3f279d17e0a:\/tmp$ exit\nuser:~$ <\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\uc740 \uace0\uc131\ub2a5\uacfc \ud655\uc7a5\uc131\uc744 \uc790\ub791\ud558\uba70, \uc624\ud508 \uc18c\uc2a4\ub85c \ub110\ub9ac \uc0ac\uc6a9\ub418\ub294 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc2dc\uc2a4\ud15c\uc785\ub2c8\ub2e4. \uc774\ubc88 \uae00\uc5d0\uc11c\ub294 PostgreSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc0dd\uc131\ubd80\ud130 \ubc31\uc5c5\uae4c\uc9c0 \uc804\ubc18\uc801\uc778 \uacfc\uc815\uc744 \uc790\uc138\ud788&hellip;<\/p>\n","protected":false},"author":1,"featured_media":603,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[28],"tags":[],"class_list":["post-600","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-computer_kr"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/realstudy.net\/wp-content\/uploads\/2024\/11\/postgres_db_backup.jpg","_links":{"self":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/600","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=600"}],"version-history":[{"count":44,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/600\/revisions"}],"predecessor-version":[{"id":661,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/600\/revisions\/661"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/media\/603"}],"wp:attachment":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=600"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=600"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=600"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}