docker中的程序无法连接到docker中的PostgreSQL

lymnna71  于 2023-05-16  发布在  Docker
关注(0)|答案(3)|浏览(204)

我用docker-compose运行我的Golang API和PostgreSQL。
我的日志出现错误connection refused：

db_1   | 
db_1   | PostgreSQL Database directory appears to contain a database; Skipping initialization
db_1   | 
api_1  | Unable to connect to database: dial tcp 0.0.0.0:5432: connect: connection refusedartpaper_api_1 exited with code 1
db_1   | 2021-12-26 15:18:35.152 UTC [1] LOG:  starting PostgreSQL 14.1 on x86_64-pc-linux-musl, compiled by gcc (Alpine 10.3.1_git20211027) 10.3.1 20211027, 64-bit
db_1   | 2021-12-26 15:18:35.152 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
db_1   | 2021-12-26 15:18:35.152 UTC [1] LOG:  listening on IPv6 address "::", port 5432
db_1   | 2021-12-26 15:18:35.216 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
db_1   | 2021-12-26 15:18:35.329 UTC [22] LOG:  database system was shut down at 2021-12-26 15:05:11 UTC
db_1   | 2021-12-26 15:18:35.515 UTC [1] LOG:  database system is ready to accept connections

我的配置：

config := pgx.ConnConfig{
        Host:     "0.0.0.0",
        Port:     5432,
        Database: "artpaper",
        User:     "admin",
        Password: "admin1",
    }

我认为docker-compose.yml或Dockerfile中的API错误，因为在正确的端口docker ps上：

0.0.0.0:5432->5432/tcp    artpaper_db_1

API的Dockerfile：

FROM golang:1.17.5-alpine3.15

WORKDIR /artpaper

COPY ./ ./

RUN go mod download // download dependencies

RUN go build ./cmd/main/main.go // compile code to one binary file

EXPOSE 8080

CMD [ "./main" ] // run binary file

docker-compose.yml:

version: "3.3"

services:
  db:
    image: postgres:14.1-alpine3.15
    volumes:
      - ./data/db:/var/lib/postgresql/data
    environment:
      - POSTGRES_DB=artpaper
      - POSTGRES_USER=admin
      - POSTGRES_PASSWORD=admin1
    ports:
      - 5432:5432
  api:
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - "8080:8080"
    depends_on:
      - db

API配置中的密码和用户，如docker-compose.yml
带有API的容器中的主机名为0.0.0.0:5432

docker

3条答案

按热度按时间
ehxuflar

ehxuflar1#

在你的Golang应用程序中尝试使用：db：5432，not0.0.0.0：5432.

version: '3.8'
services:
  db:
    image: postgres:14.1-alpine3.15
    volumes:
      - ./data/db:/var/lib/postgresql/data
    environment:
      - POSTGRES_DB=artpaper
      - POSTGRES_USER=admin
      - POSTGRES_PASSWORD=admin1
    ports:
      - 5432:5432

  api:
    build:
      context: .
      dockerfile: Dockerfile
    ports:
      - "8080:8080"
    depends_on:
      - db

  debug:
    image: postgres:14.1-alpine3.15
    command: sleep 1d

尝试连接到以下数据库：
docker-compose up -d
docker-compose exec debug ash -c 'psql -h db -U admin --dbname artpaper'

赞(0）分享  回复(0）举报  2023-05-16
des4xlb0

des4xlb02#

第一：在配置数据库主机应该是一个数据库一样，在docker-compose.yml
第二：Postgres作为一个程序没有时间在容器内打开。我在API代码中添加了连接数据库之前的延迟。

赞(0）分享  回复(0）举报  2023-05-16
wswtfjt7

wswtfjt73#

我也有类似的问题，并找到了原因，并希望分享给未来的读者。

  • docker-compose文件：
version: "3.8"

services:
  web:
    container_name: web
    image: web
    ports:
      - "80:80"
    environment:
      - REACT_APP_ACCOUNT_SERVICE=http://account:5010
      - REACT_APP_CONTENT_SERVICE=http://content:5000
      - REACT_APP_GROUP_SERVICE=http://group:5009
    networks:
      - app-network
    restart: always

  account:
    container_name: account
    image: account
    ports:
      - "5010:5000"
    environment:
      - DB_HOST=account-db
      - DB_PORT=5432
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=account
      - DB_TYPE=postgres
      - ACCOUNT_SERVICE=http://account:5010
      - GROUP_SERVICE=http://group:5009
      - CONTENT_SERVICE=http://content:5000
    depends_on:
      - account-db
    networks:
      - app-network
    restart: always

  account-db:
    container_name: account-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=account
    ports:
      - "5432:5432"
    volumes:
      - account-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

  content:
    container_name: content
    image: content
    ports:
      - "5000:5000"
    environment:
      - DB_HOST=content-db
      - DB_PORT=5433
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=content
      - DB_TYPE=postgres
    depends_on:
      - content-db
    networks:
      - app-network
    restart: always

  content-db:
    container_name: content-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=content
    ports:
      - "5433:5432"
    volumes:
      - content-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

  group:
    container_name: group
    image: group
    ports:
      - "5009:5000"
    environment:
      - DB_HOST=group-db
      - DB_PORT=5434
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=group
      - DB_TYPE=postgres
    depends_on:
      - group-db
    networks:
      - app-network
    restart: always

  group-db:
    container_name: group-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=group
    ports:
      - "5434:5432"
    volumes:
      - group-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

networks:
  app-network:

volumes:
  account-db-data:
  content-db-data:
  group-db-data:
  • 运行docker compose up后的问题
content     | Error: connect ECONNREFUSED 172.29.0.2:5433
content     |     at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1159:16) {
content     |   errno: -111,
content     |   code: 'ECONNREFUSED',
content     |   syscall: 'connect',
content     |   address: '172.29.0.2',
content     |   port: 5433
content     | }
  • 根本原因：

容器之间的内部通信发生在Docker网络中，而不是通过主机的端口。当内容服务尝试连接到content-db容器时，它是通过Docker网络连接的，其中数据库仍然在其默认端口5432上侦听。

  • 解决方案：
  • 更改所有服务的env DB_PORT=5432
version: "3.8"

services:
  web:
    container_name: web
    image: web
    ports:
      - "80:80"
    environment:
      - REACT_APP_ACCOUNT_SERVICE=http://account:5010
      - REACT_APP_CONTENT_SERVICE=http://content:5000
      - REACT_APP_GROUP_SERVICE=http://group:5009
    networks:
      - app-network
    restart: always

  account:
    container_name: account
    image: account
    ports:
      - "5010:5000"
    environment:
      - DB_HOST=account-db
      - DB_PORT=5432
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=account
      - DB_TYPE=postgres
      - ACCOUNT_SERVICE=http://account:5010
      - GROUP_SERVICE=http://group:5009
      - CONTENT_SERVICE=http://content:5000
    depends_on:
      - account-db
    networks:
      - app-network
    restart: always

  account-db:
    container_name: account-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=account
    ports:
      - "5432:5432"
    volumes:
      - account-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

  content:
    container_name: content
    image: content
    ports:
      - "5000:5000"
    environment:
      - DB_HOST=content-db
      - DB_PORT=5432
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=content
      - DB_TYPE=postgres
    depends_on:
      - content-db
    networks:
      - app-network
    restart: always

  content-db:
    container_name: content-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=content
    ports:
      - "5433:5432"
    volumes:
      - content-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

  group:
    container_name: group
    image: group
    ports:
      - "5009:5000"
    environment:
      - DB_HOST=group-db
      - DB_PORT=5432
      - DB_USERNAME=user
      - DB_PASSWORD=password
      - DB_NAME=group
      - DB_TYPE=postgres
    depends_on:
      - group-db
    networks:
      - app-network
    restart: always

  group-db:
    container_name: group-db
    image: postgres
    environment:
      - POSTGRES_USER=user
      - POSTGRES_PASSWORD=password
      - POSTGRES_DB=group
    ports:
      - "5434:5432"
    volumes:
      - group-db-data:/var/lib/postgresql/data/
    networks:
      - app-network
    restart: always

networks:
  app-network:

volumes:
  account-db-data:
  content-db-data:
  group-db-data:
  • 如何或何时使用暴露端口，如5433、5432？
  • 如果我们想从Docker容器网络外部连接数据库。
赞(0）分享  回复(0）举报  2023-05-16
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备2022004421号-2 NULL123 https://www.null123.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com