添加/链接一个Docker PostgreSQL数据库容器到我的现有Docker Python容器。

huangapple
go评论111阅读模式
英文:

Add/link a Docker postgres database container to my existing Docker python container

问题

我有一个已经docker化的Python应用程序，运行得非常好，现在我想添加一个PostgreSQL数据库。我认为最好的方法是将数据库docker化，并将其与我的Python应用程序连接起来，以便我的应用程序可以将数据存储在其中，但每次构建容器时，都会遇到相同的错误：

这是尝试构建容器时我遇到的错误：

[23165 ms] 错误：设置容器时发生错误。
[23165 ms] 在 Pte (c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:1954:3572)
[23165 ms] 在 process.processTicksAndRejections (node:internal/process/task_queues:96:5)
[23165 ms] 异步执行 rre (c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2024:3833)
[23166 ms] 异步执行 Yf (c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2024:4775)
[23166 ms] 异步执行 Dne (c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2156:12193)
[23166 ms] 异步执行 Sne (c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2156:11934)
[23176 ms] 退出码 1
[23180 ms] 命令失败：C:\Users\IT\AppData\Local\Programs\Microsoft VS Code\Code.exe --ms-enable-electron-run-as-node c:\Users\IT.vscode\extensions\ms-vscode-remote.remote-containers-0.299.0\dist\spec-node\devContainersSpecCLI.js up --user-data-folder c:\Users\IT\AppData\Roaming\Code\User\globalStorage\ms-vscode-remote.remote-containers\data --container-session-data-folder /tmp/devcontainers-f9b48955-34b9-42ed-b7eb-f5c37f6b7fb61689235866772 --workspace-folder c:\Users\IT\Documents\gys_test -- workspace-mount-consistency cached --id-label devcontainer.local_folder=c:\Users\IT\Documents\gys_test --id-label devcontainer.config_file=c:\Users\IT\Documents\gys_test.devcontainer\devcontainer.json --log-level debug --log-format json --config c:\Users\IT\Documents\gys_test.devcontainer\devcontainer.json --default-user-env-probe loginInteractiveShell --mount type=volume,source=vscode,target=/vscode,external=true -- skip-post-create --update-remote-user-uid-default on --mount-workspace-git-root true
[23180 ms] 退出码 1

这些是我的文件。它们都存储在项目主文件夹的相同目录“.devcontainer/”中：

Dockerfile:

  1. FROM mcr.microsoft.com/vscode/devcontainers/python:3.9
  2. RUN pip3 install pytest black

devcontainer.json（当前文件的版本）：

  1. {
  2.     "name": "Test development env",
  3.     "dockerComposeFile": "./docker-compose.yml",
  4.     "service": "python-app",
  5.     "workspaceFolder": "/workspace",
  6.     "settings": {
  7.         "files.eol": "\n",
  8.         "python.languageServer": "Pylance",
  9.         "python.formatting.provider": "black",
  10.         "editor.formatOnSave": true,
  11.         "files.exclude": {
  12.             "**/__pycache__": true,
  13.             "**/.pytest_cache": true,
  14.             "**/.venv": true,
  15.             "**/*.egg-info": true
  16.         },
  17.         "python.pythonPath": "/usr/local/bin/python",
  18.         "python.testing.pytestPath": "/usr/local/bin/pytest",
  19.         "python.testing.pytestEnabled": true,
  20.         "python.testing.autoTestDiscoverOnSaveEnabled": true,
  21.         "python.linting.ignorePatterns": [
  22.             ".vscode/",
  23.             "**/site-packages/",
  24.             "**/__pycache__/",
  25.             "**/.pytest_cache/",
  26.             "**/*.egg-info"
  27.         ]
  28.     },
  29.     "extensions": [
  30.         "ms-python.vscode-pylance",
  31.         "mhutchie.git-graph"
  32.     ],
  33.     "remoteUser": "vscode",
  34.     "containerUser": "vscode",
  35.     "runArgs": [
  36.         "run",
  37.         "--service-ports",
  38.         "--rm",
  39.         "python-app"
  40.     ],
  41.     "overrideCommand": true,
  42.     "postCreateCommand": "pip install -U --force-reinstall -e ."
  43. }

docker-compose.yml（当然，在我的原始文件中，用户/密码/数据库是正确的，这里我隐藏了它们）：

  1. version: '3'
  2. services:
  3.   db:
  4.     image: postgres:14.8
  5.     restart: unless-stopped //no difference with restart: always
  6.     environment:
  7.       POSTGRES_USER: <user>
  8.       POSTGRES_PASSWORD: <password>
  9.       POSTGRES_DB: <db>
  10.     volumes:
  11.       - ./postgres-data:/var/lib/postgresql/data
  13.   pgadmin:
  14.     image: dpage/pgadmin4
  15.     restart: always
  16.     environment:
  17.       PGADMIN_DEFAULT_EMAIL: <email>
  18.       PGADMIN_DEFAULT_PASSWORD: <password>
  19.     ports:
  20.       - 5432:5432
  21.     depends_on:
  22.       - db
  24.   python-app:
  25.     build:
  26.       context: .
  27.       dockerfile: Dockerfile
  28.     restart: always
  29.     volumes:
  30.       - .:/app
  31.     depends_on:
  32.       - db

这些是我用来构建仅运行良好的Python应用程序的文件：

Dockerfile：与之前相同

devcontainer.json：

  1. {
  2.     "name": "Test development env",
  3.     "dockerFile": "Dockerfile",
  4.     "settings": {
  5.         "files.eol": "\n",
  6.         "python.languageServer": "Pylance",
  7.         "python.formatting.provider": "black",
  8.         "editor.formatOnSave": true,
  9.         "files.exclude": {
  10.             "**/__pycache__": true,
  11.             "**/.pytest_cache": true,
  12.             "**/.venv": true,
  13.             "**/*.egg-info": true
  14.         },
  15.         "python.pythonPath": "/usr/local/bin/python",
  16.         "python.testing.pytestPath": "/usr/local/bin/pytest",
  17.         "python.testing.pytestEnabled": true,
  18.         "python.testing.autoTestDiscoverOnSaveEnabled": true,
  19.         "python.linting
  21. <details>
  22. <summary>英文:</summary>
  24. I have a python application dockerized that works really fine and now I want to add a postgres database. I thought the best idea is to dockerize the database and link it with my python app, so my app can store data in it, but every time the container is built, i get the same error:
  26. This is the error I get when trying to build container:
  28.     [23165 ms] Error: An error occurred setting up the container.
  29.     [23165 ms]     at Pte (c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  30.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:1954:3572)
  31.     [23165 ms]     at process.processTicksAndRejections 
  32.     (node:internal/process/task_queues:96:5)
  33.     [23165 ms]     at async rre (c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  34.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2024:3833)
  35.     [23166 ms]     at async Yf (c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  36.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2024:4775)
  37.     [23166 ms]     at async Dne (c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  38.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2156:12193)
  39.     [23166 ms]     at async Sne (c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  40.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js:2156:11934)
  41.     [23176 ms] Exit code 1
  42.     [23180 ms] Command failed: C:\Users\IT\AppData\Local\Programs\Microsoft VS Code\Code.exe 
  43.     --ms-enable-electron-run-as-node c:\Users\IT\.vscode\extensions\ms-vscode-remote.remote- 
  44.     containers-0.299.0\dist\spec-node\devContainersSpecCLI.js up --user-data-folder 
  45.     c:\Users\IT\AppData\Roaming\Code\User\globalStorage\ms-vscode-remote.remote- 
  46.     containers\data --container-session-data-folder /tmp/devcontainers-f9b48955-34b9-42ed- 
  47.     b7eb-f5c37f6b7fb61689235866772 --workspace-folder c:\Users\IT\Documents\gys_test -- 
  48.     workspace-mount-consistency cached --id-label 
  49.     devcontainer.local_folder=c:\Users\IT\Documents\gys_test --id-label 
  50.     devcontainer.config_file=c:\Users\IT\Documents\gys_test\.devcontainer\devcontainer.json 
  51.     --log-level debug --log-format json --config 
  52.     c:\Users\IT\Documents\gys_test\.devcontainer\devcontainer.json --default-user-env-probe 
  53.     loginInteractiveShell --mount type=volume,source=vscode,target=/vscode,external=true -- 
  54.     skip-post-create --update-remote-user-uid-default on --mount-workspace-git-root true
  55.     [23180 ms] Exit code 1
  57. These are my files. All of them are stored in the same directory &quot;.devcontainer/&quot; in the main folder of the project:
  59. **Dockerfile**:
  61.     FROM mcr.microsoft.com/vscode/devcontainers/python:3.9
  62.     RUN pip3 install pytest black
  64. **devcontainer.json** (current version of the file):
  66.     {
  67.     &quot;name&quot;: &quot;Test development env&quot;,
  68.     &quot;dockerComposeFile&quot;: &quot;./docker-compose.yml&quot;,
  69.     &quot;service&quot;: &quot;python-app&quot;,
  70.     &quot;workspaceFolder&quot;: &quot;/workspace&quot;,
  71.     &quot;settings&quot;: {
  72.       &quot;files.eol&quot;: &quot;\n&quot;,
  73.       &quot;python.languageServer&quot;: &quot;Pylance&quot;,
  74.       &quot;python.formatting.provider&quot;: &quot;black&quot;,
  75.       &quot;editor.formatOnSave&quot;: true,
  76.       &quot;files.exclude&quot;: {
  77.         &quot;**/__pycache__&quot;: true,
  78.         &quot;**/.pytest_cache&quot;: true,
  79.         &quot;**/.venv&quot;: true,
  80.         &quot;**/*.egg-info&quot;: true
  81.       },
  82.       &quot;python.pythonPath&quot;: &quot;/usr/local/bin/python&quot;,
  83.       &quot;python.testing.pytestPath&quot;: &quot;/usr/local/bin/pytest&quot;,
  84.       &quot;python.testing.pytestEnabled&quot;: true,
  85.       &quot;python.testing.autoTestDiscoverOnSaveEnabled&quot;: true,
  86.       &quot;python.linting.ignorePatterns&quot;: [
  87.         &quot;.vscode/&quot;,
  88.         &quot;**/site-packages/&quot;,
  89.         &quot;**/__pycache__/&quot;,
  90.         &quot;**/.pytest_cache/&quot;,
  91.         &quot;**/*.egg-info&quot;
  92.       ]
  93.     },
  94.     &quot;extensions&quot;: [
  95.       &quot;ms-python.vscode-pylance&quot;,
  96.       &quot;mhutchie.git-graph&quot;
  97.     ],
  98.     &quot;remoteUser&quot;: &quot;vscode&quot;,
  99.     &quot;containerUser&quot;: &quot;vscode&quot;,
  100.     &quot;runArgs&quot;: [
  101.       &quot;run&quot;,
  102.       &quot;--service-ports&quot;,
  103.       &quot;--rm&quot;,
  104.       &quot;python-app&quot;
  105.     ],
  106.     &quot;overrideCommand&quot;: true, // get the same error with/out this line, no difference
  107.     &quot;postCreateCommand&quot;: &quot;pip install -U --force-reinstall -e .&quot;
  108.   }
  110. **docker-compose.yml**. (of course users/passwords/db are right in my original files, I hide them here)
  112.     version: &#39;3&#39;
  113.     services:
  114.       db:
  115.         image: postgres:14.8
  116.         restart: unless-stopped //no difference with restart: always
  117.         environment:
  118.           POSTGRES_USER: &lt;user&gt;
  119.           POSTGRES_PASSWORD: &lt;password&gt;
  120.           POSTGRES_DB: &lt;db&gt;
  121.     volumes:
  122.       - ./postgres-data:/var/lib/postgresql/data
  124.     pgadmin:
  125.       image: dpage/pgadmin4
  126.       restart: always
  127.       environment:
  128.         PGADMIN_DEFAULT_EMAIL: &lt;email&gt;
  129.         PGADMIN_DEFAULT_PASSWORD: &lt;password&gt;
  130.       ports:
  131.         - 5432:5432
  132.       depends_on:
  133.         - db
  135.     python-app:
  136.       build:
  137.         context: .
  138.         dockerfile: Dockerfile
  139.       restart: always
  140.       volumes:
  141.         - .:/app
  142.       depends_on:
  143.         - db
  146. And these are the files I&#39;m using to build only my python app that works well:
  148. **Dockerfile**: same as before
  150. **devcontainer.json**
  152.     {
  153.     &quot;name&quot;: &quot;Test development env&quot;,
  154.     &quot;dockerFile&quot;: &quot;Dockerfile&quot;,
  155.     &quot;settings&quot;: {
  156.         &quot;files.eol&quot;: &quot;\n&quot;,
  157.         &quot;python.languageServer&quot;: &quot;Pylance&quot;,
  158.         &quot;python.formatting.provider&quot;: &quot;black&quot;,
  159.         &quot;editor.formatOnSave&quot;: true,
  160.         &quot;files.exclude&quot;: {
  161.             &quot;**/__pycache__&quot;: true,
  162.             &quot;**/.pytest_cache&quot;: true,
  163.             &quot;**/.venv&quot;: true,
  164.             &quot;**/*.egg-info&quot;: true
  165.         },
  166.         &quot;python.pythonPath&quot;: &quot;/usr/local/bin/python&quot;,
  167.         &quot;python.testing.pytestPath&quot;: &quot;/usr/local/bin/pytest&quot;,
  168.         &quot;python.testing.pytestEnabled&quot;: true,
  169.         &quot;python.testing.autoTestDiscoverOnSaveEnabled&quot;: true,
  170.         &quot;python.linting.ignorePatterns&quot;: [
  171.             &quot;.vscode/&quot;,
  172.             &quot;**/site-packages/&quot;,
  173.             &quot;**/__pycache__/&quot;,
  174.             &quot;**/.pytest_cache/&quot;,
  175.             &quot;**/*.egg-info&quot;
  176.         ],
  177.     },
  178.     &quot;extensions&quot;: [
  179.         &quot;ms-python.vscode-pylance&quot;,
  180.         &quot;mhutchie.git-graph&quot;,
  181.     ],
  182.     &quot;remoteUser&quot;: &quot;vscode&quot;,
  183.     &quot;containerUser&quot;: &quot;vscode&quot;,
  184.     &quot;runArgs&quot;: [
  185.         &quot;--network=host&quot;,
  186.     ],
  187.     &quot;postCreateCommand&quot;: &quot;pip install -U --force-reinstall -e .&quot;
  188.     }
  190. Any ideas on how to do this? I think I have something wrong in my files but I also think I&#39;m probably missing something... in my VSCode I have the Dev Containers and Remote Cevelopment extensions installed, could be the problem any of them? How do I fix it?
  192. Thanks in advance, regards!
  194. </details>
  197. # 答案1
  198. **得分**: 0
  200. 我尝试了这个并且有效。保留了我的原始devcontainer.json和Dockerfile文件，在docker-compose.yml中添加了以下内容：

version: '3'
services:
db:
image: postgres:15.3
restart: always
environment:
POSTGRES_USER: <my_user>
POSTGRES_PASSWORD: <my_pass>
POSTGRES_DB: <my_db>
volumes:
- ./postgres-data:/var/lib/postgresql/data
ports:
- 5432:5432

  2. <details>
  3. <summary>英文:</summary>
  4. I tryied this and worked. Kept my original devcontainer.json &amp; Dockerfile files, and in the docker-compose.yml I put this:
  5. version: &#39;3&#39;
  6. services:
  7. db:
  8. image: postgres:15.3
  9. restart: always
  10. environment:
  11. POSTGRES_USER: &lt;my_user&gt;
  12. POSTGRES_PASSWORD: &lt;my_pass&gt;
  13. POSTGRES_DB: &lt;my_db&gt;
  14. volumes:
  15. - ./postgres-data:/var/lib/postgresql/data
  16. ports:
  17. - 5432:5432
  18. </details>

huangapple
  • 本文由 发表于 2023年7月13日 16:30:44
  • 转载请务必保留本文链接：https://go.coder-hub.com/76677380.html
  • docker
  • docker-compose
  • postgresql
  • python
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定