如何与Docker共享本地Postgres数据库？[副本]

Question

我有一个django项目与PostgreS数据库。我需要在docker容器中使用我的本地数据库。如何与docker容器共享机器的localhost？My Docker-compose.yml：

  version: '3'
  services:
    web:
      build: ./
      network_mode: "host"
      command: bash -c "python manage.py makemigrations && python manage.py migrate && python manage.py collectstatic --noinput --i rest_framework && gunicorn orion-amr.wsgi:application --bind 0.0.0.0:8000 --workers=2"
      ports:
        - "${webport}:8000"
        - "${pgport}:${pgport}"
      env_file:
        - ./.env

Django Settings.py：

DATABASES = {
    'default': {
        'ENGINE': 'django.contrib.gis.db.backends.postgis',
        'NAME': os.environ.get('pgdatabase'),
        'USER': os.environ.get('pguser'),
        'PASSWORD': os.environ.get('pgpassword'),
        'HOST': os.environ.get('pghostname'),
        'PORT': os.environ.get('pgport'),
    }
}

我添加了

listen_addresses = '*'  

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# IPv4 local connections:
host    all             all             0.0.0.0/0               trust
# IPv6 local connections:
host    all             all             ::/0                    trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
host    replication     all             127.0.0.1/32            trust
host    replication     all             ::1/128                 trust

现在我有一个错误：

web_1  | django.db.utils.OperationalError: could not connect to server: Connection refused
web_1  |        Is the server running on host "127.0.0.1" and accepting
web_1  |        TCP/IP connections on port 5432?
web_1  |

谁能帮我？求求你！

Answer 1

os.environ.get('pghostname')似乎指向127.0.0.1，其中127.0.0.1表示此容器，而不是主机DB。作为错误

Is the server running on host "127.0.0.1" and accepting

要与主机数据库连接，您需要为mac和Windowshost.docker.internal提供特殊的DNS。DB主机应为

'HOST': "host.docker.internal"

要与主机DB连接，或者如果您是在Linux上，那么它应该是

'HOST': "HOST_IP"

您可以从ifconfig获取主机IP。