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
相关产品推荐
相关产品推荐

