{"id":531,"date":"2024-11-15T05:50:43","date_gmt":"2024-11-15T05:50:43","guid":{"rendered":"https:\/\/realstudy.net\/?p=531"},"modified":"2024-11-29T05:44:15","modified_gmt":"2024-11-29T05:44:15","slug":"postgresql-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/realstudy.net\/?p=531&lang=ko","title":{"rendered":"PostgreSQL \uc124\uce58 – Docker, Kubernetes"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t
Postgresql \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c Docker\ub85c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uacfc Kubernetes\uc5d0 HELM\uc73c\ub85c \uac04\ud3b8\ud558\uac8c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \uc124\uce58\ub97c \uc704\ud574 \ud544\uc694\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub3c4 \uc81c\uacf5\ud560 \uc608\uc815\uc774\uba70, \uc81c\uacf5\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc790\uc2e0\uc758 \ud658\uacbd\uc5d0 \ub9de\uac8c \uc218\uc815\ud558\uc5ec \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
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

\uc0ac\uc804 \uc900\ube44 \uc0ac\ud56d<\/strong>:<\/h3>
  • Docker<\/strong> \ubc0f Docker-Compose<\/strong>\uac00 \uc124\uce58\ub41c \ud658\uacbd<\/li>
  • Kubernetes<\/strong> \ud074\ub7ec\uc2a4\ud130 \uc811\uadfc \uad8c\ud55c<\/li>
  • Helm<\/strong>\uc774 \uc124\uce58\ub41c \ud658\uacbd<\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    \uc804\uccb4 \ub0b4\uc6a9<\/strong>:<\/h3>\n
      \n \t
    1. Docker Compose\ub85c \uc124\uce58<\/strong>:\n
        \n \t
      • Localhost\uc5d0 Docker\ub97c \uc774\uc6a9\ud558\uc5ec \uc124\uce58.<\/li>\n<\/ul>\n<\/li>\n \t
      • Kubernetes\uc5d0 \uc124\uce58<\/b>:\n
          \n \t
        • Helm\uc744 \uc774\uc6a9\ud558\uc5ec \uc124\uce58.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\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
          \n\t\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t

          * Local\uc5d0 Docker Compose \uc774\uc6a9<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t\t\t
          * \uc608\uc81c\uc5d0\uc11c \ub370\uc774\ud130 \ud30c\uc77c\uc744 \uc800\uc7a5\ud560 \ub85c\uceec\uacbd\ub85c\ub97c “\/data\/postgres”\ub85c \uc9c0\uc815 \ud588\uc2b5\ub2c8\ub2e4. \uc774 \uacbd\uc6b0 docker\uc5d0\uc11c \uc0ac\uc6a9\ud558\ub294 group id, user id\uc640 \ub370\uc774\ud130 \uacbd\ub85c\uc758 \uc18c\uc720\uc790\uac00 \uac19\uc544\uc57c \ud558\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130 \uacbd\ub85c \uc0dd\uc131\uacfc \uc18c\uc720\uc790 \uc124\uc815\uc774 \uba3c\uc800 \uc774\ub8e8\uc5b4 \uc838\uc57c \ud569\ub2c8\ub2e4.
          * bitnami postgresql \ub294 group id\ub85c 1001\uc744 user id\ub85c 1001\uc744 \uc0ac\uc6a9 \ud569\ub2c8\ub2e4.<\/div>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
          \n\t\t\t\t
          \n\t\t\t\t\t\t\t
          \n\t\t\t
          \n\t\t\t\t\n\t\t\t\t\tuser:~$ sudo mkdir -p \/data\/postgres\nuser:~$ sudo chown 1001:1001 \/data\/postgres<\/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-42545f0 elementor-widget elementor-widget-text-editor\" data-id=\"42545f0\" 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><b>docker-compose.yml<\/b><\/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-019662d elementor-widget elementor-widget-code-highlight\" data-id=\"019662d\" 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-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>services:\n# define postgresql container\n  postgresql:\n    image: docker.io\/bitnami\/postgresql:17\n    restart: unless-stopped\n    container_name: postgresql\n    ports:\n      - '5432:5432'\n    volumes:\n      - '\/data\/postgres:\/bitnami\/postgresql'\n    environment:\n      - POSTGRESQL_POSTGRES_PASSWORD=postgres\n      - POSTGRESQL_USERNAME=rsnet\n      - POSTGRESQL_PASSWORD=rsnet\n      - POSTGRESQL_DATABASE=rsnet<\/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-b188082 elementor-widget elementor-widget-text-editor\" data-id=\"b188082\" 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><strong>\uc2e4\ud589 &amp; \uc81c\uac70<\/strong><\/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-ac7c238 elementor-widget elementor-widget-code-highlight\" data-id=\"ac7c238\" 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># start container\nuser:~$ docker compose up postgresql -d\n\n# stop container\nuser:~$ docker container stop <container hash value>\n\n# remove container\nuser:~$ docker container rm <container hash value>\n<\/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-a141561 e-flex e-con-boxed e-con e-parent\" data-id=\"a141561\" 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-492e017 elementor-widget elementor-widget-heading\" data-id=\"492e017\" 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\">* Local\uc5d0 Docker Compose \uc774\uc6a9 : vector extension \uc0ac\uc6a9<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dc81af7 elementor-widget elementor-widget-text-editor\" data-id=\"dc81af7\" 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\uc5d0\uc11c \ubca1\ud130 DB \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 <code>pgvector<\/code> \ud655\uc7a5\uc774 \ud3ec\ud568\ub41c \uc774\ubbf8\uc9c0\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub9cc\uc57d <a href=\"https:\/\/realstudy.net\" target=\"_new\" rel=\"noopener\">realstudy.net<\/a>\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 DockerHub \uc774\ubbf8\uc9c0\ub97c \ud65c\uc6a9\ud558\uace0 \uc2f6\ub2e4\uba74, \uc544\ub798\uc640 \uac19\uc774 image\uc5d0 \uacbd\ub85c\ub97c \uc124\uc815\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-08bc99f elementor-widget elementor-widget-code-highlight\" data-id=\"08bc99f\" 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-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp>services:\n# define postgresql container\n  postgresql:\n    image: nockchun\/postgresql_pgvector.rs:17.2.0_0.4.0\n    restart: unless-stopped\n    container_name: postgresql\n    ports:\n      - '5432:5432'\n    volumes:\n      - '\/data\/postgres:\/bitnami\/postgresql'\n    environment:\n      - POSTGRESQL_POSTGRES_PASSWORD=postgres\n      - POSTGRESQL_USERNAME=rsnet\n      - POSTGRESQL_PASSWORD=rsnet\n      - POSTGRESQL_DATABASE=rsnet<\/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-cfc7d83 elementor-widget elementor-widget-text-editor\" data-id=\"cfc7d83\" 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 \ucee8\ud14c\uc774\ub108 Shell\ub85c \ub4e4\uc5b4\uac00\uc11c \ubca1\ud130 DB \ud655\uc7a5 \uae30\ub2a5\uc744 \ub4f1\ub85d(\ub85c\ub529)\ud574\uc57c \ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 \ucee8\ud14c\uc774\ub108\ub97c \ub2e4\uc2dc \uc2dc\uc791\ud574 \uc8fc\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-c7986e0 elementor-widget elementor-widget-code-highlight\" data-id=\"c7986e0\" 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-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp># Run the container shell\nuser:~$ docker compose exec postgresql bash\n\n# Loading vector extension\ncontainer:\/$ psql -U postgres -c 'ALTER SYSTEM SET shared_preload_libraries = \"vectors.so\"'\ncontainer:\/$ psql -U postgres -c 'ALTER SYSTEM SET search_path TO \"$user\", public, vectors'\n\n# Restart container\nuser:~$ docker compose restart postgresql<\/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-8ff07d0 elementor-widget elementor-widget-text-editor\" data-id=\"8ff07d0\" 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>* psql\uc774\ub098 dbeaver\uac19\uc740 query \ud234\uc5d0\uc11c \ubca1\ud130 DB \ud655\uc7a5 \uae30\ub2a5\uc744 \ud65c\uc131\ud654 \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-a05a49f elementor-widget elementor-widget-code-highlight\" data-id=\"a05a49f\" 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-javascript line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-javascript\">\n\t\t\t\t\t<xmp># Enable the extension\npsql:~$ CREATE EXTENSION vectors;\n\n# Disable the extension\npsql:\/$ DROP EXTENSION IF EXISTS vectors;<\/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-a18e46b e-flex e-con-boxed e-con e-parent\" data-id=\"a18e46b\" 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-6406090 elementor-widget elementor-widget-heading\" data-id=\"6406090\" 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\">* Kubernetes\uc5d0  HELM \uc774\uc6a9<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-13d41da elementor-widget elementor-widget-text-editor\" data-id=\"13d41da\" 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>Kubernetes \ud658\uacbd\uc5d0\uc11c PostgreSQL\uc744 \uc124\uce58\ud560 \ub54c Helm\uc744 \ud65c\uc6a9\ud558\uba74 \uac04\ub2e8\ud558\uace0 \ud6a8\uc728\uc801\uc73c\ub85c \uc124\uce58 \ubc0f \uad00\ub9ac\ub97c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud2b9\ud788, \ud558\ub098\uc758 \uba85\ub839\uc73c\ub85c \uc8fc\uc694 \uc124\uc815\uc744 \uc644\ub8cc\ud560 \uc218 \uc788\uc5b4 \ucd08\ubcf4\uc790\ub3c4 \uc27d\uac8c \ub530\ub77c \ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774\ubc88 \uae00\uc5d0\uc11c\ub294 Bitnami\uc758 Helm Chart\uc640 Docker \uc774\ubbf8\uc9c0\ub97c \ud65c\uc6a9\ud574 PostgreSQL\uc744 \uc124\uce58\ud558\ub294 \uac00\uc7a5 \uac04\ub2e8\ud55c \ubc29\ubc95\uc744 \uc18c\uac1c\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-2d6ef5a elementor-widget elementor-widget-text-editor\" data-id=\"2d6ef5a\" 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><b>repository \ub4f1\ub85d<\/b><\/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-3160d3e elementor-widget elementor-widget-code-highlight\" data-id=\"3160d3e\" 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>user:~$ helm repo add bitnami https:\/\/charts.bitnami.com\/bitnami\nuser:~$ helm repo update<\/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-6d6e223 elementor-widget elementor-widget-text-editor\" data-id=\"6d6e223\" 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><b>\uc124\uc815 \uc635\uc158 \ud655\uc778<\/b><\/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-b5332ab elementor-widget elementor-widget-code-highlight\" data-id=\"b5332ab\" 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-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>user:~$ helm show values bitnami\/postgresql > postgresql-values.yaml<\/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-b8820ee elementor-widget elementor-widget-text-editor\" data-id=\"b8820ee\" 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>* Helm\uc5d0 values\uc5d0\uc11c \uc124\uc815\ud560 \uc218 \uc788\ub294 \uc635\uc158\uacfc \uac01 \uc635\uc158\ub4e4\uc758 \uc815\ud655\ud55c \uc704\uce58\ub97c \ud655\uc778\ud558\uae30 \uc704\ud574 values.yaml \ud30c\uc77c\ub85c \uc800\uc7a5 \ud569\ub2c8\ub2e4.<br \/>* \uacf5\uc2dd\ubb38\uc11c\ub97c \ud1b5\ud574 \ud655\uc778\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. : <a href=\"https:\/\/artifacthub.io\/packages\/helm\/bitnami\/postgresql\" target=\"_blank\" rel=\"noopener\">https:\/\/artifacthub.io\/packages\/helm\/bitnami\/postgresql<\/a><\/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-e3569e7 elementor-widget elementor-widget-text-editor\" data-id=\"e3569e7\" 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><strong>\uc124\uce58<\/strong><\/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-06c2e2a elementor-widget elementor-widget-code-highlight\" data-id=\"06c2e2a\" 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>user:~$ helm install postgresql bitnami\/postgresql --namespace postgresql --create-namespace \\\n  --set global.postgresql.auth.postgresPassword=postgres \\\n  --set global.postgresql.auth.username=rsnet \\\n  --set global.postgresql.auth.password=rsnet \\\n  --set global.postgresql.auth.database=rsnet \\\n  --set primary.persistence.storageClass=local-path \\\n  --set primary.persistence.size=50Gi \\\n  --set primary.resources.requests.memory=512Mi \\\n  --set primary.resources.limits.memory=30000Mi \\\n  --set primary.service.type=LoadBalancer \\\n  --set primary.service.port=5432<\/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-21daec5 elementor-widget elementor-widget-text-editor\" data-id=\"21daec5\" 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\uc5d0\uc11c \ubca1\ud130 DB \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud558\ub824\uba74 <code>pgvector<\/code> \ud655\uc7a5\uc774 \ud3ec\ud568\ub41c \uc774\ubbf8\uc9c0\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub9cc\uc57d <a href=\"https:\/\/realstudy.net\" target=\"_new\" rel=\"noopener\">realstudy.net<\/a>\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 DockerHub \uc774\ubbf8\uc9c0\ub97c \ud65c\uc6a9\ud558\uace0 \uc2f6\ub2e4\uba74, \uc544\ub798\uc640 \uac19\uc774 <code>image.repository<\/code>\uc640 <code>image.tag<\/code>\ub97c \uc124\uc815\ud558\uc5ec \uc124\uce58\ud560 Docker \ucee8\ud14c\uc774\ub108 \uc774\ubbf8\uc9c0\ub97c \uc9c0\uc815\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-775fa49 elementor-widget elementor-widget-code-highlight\" data-id=\"775fa49\" 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>user:~$ helm install postgresql bitnami\/postgresql --namespace postgresql --create-namespace \\\n  --set image.repository=nockchun\/postgresql_pgvector.rs \\\n  --set image.tag=17.2.0_0.4.0 \\\n  --set global.postgresql.auth.postgresPassword=postgres \\\n  --set global.postgresql.auth.username=rsnet \\\n  --set global.postgresql.auth.password=rsnet \\\n  --set global.postgresql.auth.database=rsnet \\\n  --set primary.persistence.storageClass=local-path \\\n  --set primary.persistence.size=50Gi \\\n  --set primary.resources.requests.memory=512Mi \\\n  --set primary.resources.limits.memory=30000Mi \\\n  --set primary.service.type=LoadBalancer \\\n  --set primary.service.port=5432<\/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-4158678 elementor-widget elementor-widget-text-editor\" data-id=\"4158678\" 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>* pgvector \ud655\uc7a5\uc744 \ud3ec\ud568\ud55c \uc774\ubbf8\uc9c0\ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \uc704\ucabd &#8220;Local\uc5d0 Docker Compose \uc774\uc6a9 : vector extension \uc0ac\uc6a9&#8221;\uc5d0\uc11c \uc124\uba85\ud55c \ubc29\ubc95\ub300\ub85c \uc124\uce58 \uc774\ud6c4\uc5d0 \ubca1\ud130 DB \ud655\uc7a5 \uae30\ub2a5\uc744 \ub4f1\ub85d(\ub85c\ub529)\ud558\uace0 query tool\uc5d0\uc11c \ud65c\uc131\ud654 \ud558\uc5ec\uc57c \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-eecebd6 elementor-widget elementor-widget-text-editor\" data-id=\"eecebd6\" 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><strong>\uc2e4\ud589 &amp; \uc81c\uac70<\/strong><\/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-211e646 elementor-widget elementor-widget-code-highlight\" data-id=\"211e646\" 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-python line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp># Check if it is installed and running properly.\nuser:~$ kubectl get all -n postgresql<\/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 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c Docker\ub85c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uacfc Kubernetes\uc5d0 HELM\uc73c\ub85c \uac04\ud3b8\ud558\uac8c \uc124\uce58\ud558\ub294 \ubc29\ubc95\uc744 \uc124\uba85\ud569\ub2c8\ub2e4. \uc124\uce58\ub97c \uc704\ud574 \ud544\uc694\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub3c4 \uc81c\uacf5\ud560 \uc608\uc815\uc774\uba70, \uc81c\uacf5\ud55c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc790\uc2e0\uc758&hellip;<\/p>\n","protected":false},"author":1,"featured_media":532,"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-531","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\/postgresql_install.jpeg","_links":{"self":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/531","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=531"}],"version-history":[{"count":87,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/531\/revisions"}],"predecessor-version":[{"id":1039,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/posts\/531\/revisions\/1039"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=\/wp\/v2\/media\/532"}],"wp:attachment":[{"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=531"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=531"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/realstudy.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=531"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}