Nodejs 不连接 Postgres（在 Docker 容器中）

连接 Postgres 的问题。 IP和端口匹配，但是由于某些原因node js无法连接到PG

2023-04-26T05:31:58.439015532Z connection error Error: connect ECONNREFUSED 127.0.0.1:5432
2023-04-26T05:31:58.439078870Z     at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1570:16)

Connect DB（在PC上工作正常） db.js

const Pool = require('pg').Pool
const pool = new Pool({
  host: 'localhost',
  port: 5432,
  database: 'postgres',
  user: 'postgres',
  password: '1234',
})
module.exports = pool

Nodejs 开始工作良好，但在尝试连接到数据库时崩溃 服务器/Dockerfile

FROM node:alpine
FROM postgres
COPY init.sql /docker-entrypoint-initdb.d/

WORKDIR /app
ADD init.sql /docker-entrypoint-initdb.d/

EXPOSE 5000

COPY package*.json ./

RUN npm install

COPY . ./

CMD ["npm", "run", "server"]

默认配置 码头工人撰写

#Version
version: '3'

#services
services:
  #name-another
  server:
    #build-images-from-Dockerfile (create)
    build: ./server
    ports:
      - "5000:5000"
  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080
  postgres:
      image: postgres:11.4-alpine
      restart: always
      ports:
        - "5432:5432"
      environment:
        POSTGRES_USER: postgres,
        POSTGRES_PASSWORD: 1234,
        POSTGRES_DB: postgres

提前谢谢大家。我正在第三天解决这个问题。