从docker容器中连接到localhostpostgres数据库[副本]

Question

我有一个linux postgres数据库，在我的本地主机端口5432上运行。我的机器网卡的IP是192.168.68.80。我的postgres配置文件如下所示：

listen_addresses = '*'

host    all             all             0.0.0.0/0               md5
host    all             all             ::/0                    md5

现在，我想从docker容器中运行的节点应用程序连接到这个数据库。这是我的环境变量文件加载到节点时的样子：

PGHOST=localhost // Host of the postgres db server
PGPORT=5432 // Port of the postgres db

完成此设置后，我使用docker文件构建docker映像。然后，我尝试在linux上使用以下命令将dockerfile作为容器运行：

sudo docker run --network="host" --env-file .env -p 3000:3000 repo:tag

，应用开始运行，并侦听端口 3000 上的连接。但是，每当我尝试连接到该应用程序时，该应用程序都无法连接到postgres数据库服务器，并给出以下错误：

/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:172
                reject(new sequelizeErrors.ConnectionRefusedError(err));
                       ^

ConnectionRefusedError [SequelizeConnectionRefusedError]: connect ECONNREFUSED 127.0.0.1:5432
    at Client._connectionCallback (/node_modules/sequelize/lib/dialects/postgres/connection-manager.js:172:24)
    at Client._handleErrorWhileConnecting (/node_modules/pg/lib/client.js:305:19)
    at Client._handleErrorEvent (/node_modules/pg/lib/client.js:315:19)
    at Connection.emit (node:events:394:28)
    at Socket.reportStreamError (/node_modules/pg/lib/connection.js:52:12)
    at Socket.emit (node:events:394:28)
    at emitErrorNT (node:internal/streams/destroy:193:8)
    at emitErrorCloseNT (node:internal/streams/destroy:158:3)
    at processTicksAndRejections (node:internal/process/task_queues:83:21) {
  parent: Error: connect ECONNREFUSED 127.0.0.1:5432
      at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1133:16) {
    errno: -111,
    code: 'ECONNREFUSED',
    syscall: 'connect',
    address: '127.0.0.1',
    port: 5432
  },
  original: Error: connect ECONNREFUSED 127.0.0.1:5432
      at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1133:16) {
    errno: -111,
    code: 'ECONNREFUSED',
    syscall: 'connect',
    address: '127.0.0.1',
    port: 5432
  }
}

我不知道为什么连接被拒绝，因为它似乎应该能够连接。

我当前的ip表，以防有帮助：

user$ sudo iptables --list
Chain INPUT (policy ACCEPT)
target     prot opt source               destination         

Chain FORWARD (policy DROP)
target     prot opt source               destination         
DOCKER-USER  all  --  anywhere             anywhere            
DOCKER-ISOLATION-STAGE-1  all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere             ctstate RELATED,ESTABLISHED
DOCKER     all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere             ctstate RELATED,ESTABLISHED
DOCKER     all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere            
ACCEPT     all  --  anywhere             anywhere            

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination         

Chain DOCKER (2 references)
target     prot opt source               destination         

Chain DOCKER-ISOLATION-STAGE-1 (1 references)
target     prot opt source               destination         
DOCKER-ISOLATION-STAGE-2  all  --  anywhere             anywhere            
DOCKER-ISOLATION-STAGE-2  all  --  anywhere             anywhere            
RETURN     all  --  anywhere             anywhere            

Chain DOCKER-ISOLATION-STAGE-2 (2 references)
target     prot opt source               destination         
DROP       all  --  anywhere             anywhere            
DROP       all  --  anywhere             anywhere            
RETURN     all  --  anywhere             anywhere            

Chain DOCKER-USER (1 references)
target     prot opt source               destination         
RETURN     all  --  anywhere             anywhere

Answer 1

docker 在容器中有自己的网络。当你说“PGHOST=localhost”时，它将连接到 docker 容器的内部 localhost（与你的计算机 localhost 无关），而不是你的计算机 localhost。你必须放置一个运行你的 docker 和机器的同一网络。它可以是您的网络 IP。您可以通过在linux中给出命令“ip a”来获取IP。在我的情况下，我的wifi是公共网络，IP是“192.168.X.X/24”，给出“192.168.X.X”而不是“localhost”将适用于我。

Answer 2

从容器中，主机的IP地址172.17.0.1。因此您应该连接到172.17.0.1:5432。