You need to enable JavaScript to run this app.
优惠活动
大模型
产品
解决方案
定价
更多

Docker部署PostgreSQL无法通过Dbeaver连接,请求排查方案

Docker部署Mage-AI与PostgreSQL后Dbeaver认证错误排查求助

我通过Docker部署了mage-ai与PostgreSQL容器,容器初始化时已成功创建数据库,且可通过Docker Desktop验证其存在。但尝试使用Dbeaver工具连接该数据库时,始终出现认证错误,目前已无排查思路,恳请提供解决方向。

相关配置文件

Docker Compose YAML文件(本地卷路径已简化)

mage:
  image: mageai/mageai:latest
  command: mage start ${PROJECT_NAME}
  env_file:
    - .env
  build:
    context: .
    dockerfile: Dockerfile
  environment:
    USER_CODE_PATH: /home/src/${PROJECT_NAME}
    POSTGRES_DBNAME: ${POSTGRES_DBNAME}
    POSTGRES_SCHEMA: ${POSTGRES_SCHEMA}
    POSTGRES_USER: ${POSTGRES_USER}
    POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
    POSTGRES_HOST: ${POSTGRES_HOST}
    POSTGRES_PORT: ${POSTGRES_PORT}
  ports:
    - 6789:6789
  volumes:
    - C:/docker_volume/:/home/src/
  restart: on-failure:5
postgres:
  image: postgres:14
  restart: on-failure
  container_name: ${PROJECT_NAME}-postgres
  env_file:
    - .env
  environment:
    POSTGRES_DB: ${POSTGRES_DBNAME}
    POSTGRES_USER: ${POSTGRES_USER}
    POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
  ports:
    - "${POSTGRES_PORT}:5432"
  volumes:
    - C:\docker_volume:/var/lib/postgresql/data
    - C:\init.sql:/docker-entrypoint-initdb.d/init.sql

注:通过.env文件导入变量,登录时确保信息一致,该因素已排除。

pg_hba.conf文件内容

# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     md5
host    replication     all             127.0.0.1/32            md5
host    replication     all             ::1/128                 md5

host all all all scram-sha-256

连接错误截图

认证错误截图

内容的提问来源于stack exchange,提问作者Zeka Farzali

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.06.17 14:47:17