正在从docker-compose文件连接到Postgres docker容器[重复]

Question

我有两个项目。第一个包含以下docker-compose.yml:

# pg/docker-compose.yml
version: "3"
services:
  postgres:
    image: postgres
    environment:
      POSTGRES_USER: pguser
      POSTGRES_DB: pg
    ports:
      - "5432:5432"
    volumes:
      - "postgres-data:/var/lib/postgresql/data"
    networks:
      - some_net

volumes:
  postgres-data:

networks:
  some_net:
    driver: bridge

第二个项目有这个docker compose文件：

# pg_client/docker-compose.yml
version: "3"
services:
  postgres_client:
    image: tmaier/postgresql-client
    command: postgres://pguser@localhost:5432/pg
    networks:
      - pg_some_net

networks:
  pg_some_net:
    external: true

我可以很好地从命令行连接到我的Postgres数据库：

$ psql postgres://pgmuser@localhost:5432/pg
psql (12.1)
Type "help" for help.

pg=#

但是，当postgres_client容器尝试连接时（在运行docker-compose up之后），它会失败，并表示

postgres_client_1  | psql: could not connect to server: Connection refused
postgres_client_1  |        Is the server running on host "localhost" (127.0.0.1) and accepting
postgres_client_1  |        TCP/IP connections on port 5432?
postgres_client_1  | could not connect to server: Address not available
postgres_client_1  |        Is the server running on host "localhost" (::1) and accepting
postgres_client_1  |        TCP/IP connections on port 5432?

在编写Postgres连接URI时，关于docker-compose有什么特别的地方需要说明吗？

非常感谢任何帮助。

Answer 1

postgres的主机名应解析为postgres而不是localhost。你可以试试

command: postgres://pguser@postgres:5432/pg