kartoza/postgis容器仅pgadmin可连接,CloudBeaver等工具无法连接求助
求助:CloudBeaver无法连接Docker容器内的PostGIS数据库
这个问题已经困扰我多日,查阅多篇技术帖子并尝试多种解决方案均无效果,现诚挚向解决过同类问题的用户求助:
docker-compose.yml 配置
services: postgis: image: kartoza/postgis:${POSTGIS_VERSION_TAG} container_name: postgis ports: - "5432:5432" environment: - POSTGRES_USER=${POSTGRES_USER} - POSTGRES_PASS=${POSTGRES_PASS} - POSTGRES_DB=${POSTGRES_DB} - ALLOW_IP_RANGE=${POSTGRES_ALLOW_IP_RANGE} - POSTGRES_MULTIPLE_EXTENSIONS=${POSTGRES_MULTIPLE_EXTENSIONS} - POSTGRES_DATA_VOLUME:${POSTGRES_DATA_VOLUME} restart: on-failure volumes: - postgis-data:${POSTGRES_DATA_VOLUME} networks: - postgis_network pgadmin: image: dpage/pgadmin4:${PGADIM_VERION_TAG} container_name: ${PGADIM_CONTAINER_NAME} ports: - "5050:80" restart: always environment: - PGADMIN_DEFAULT_EMAIL=${PGADMIN_DEFAULT_EMAIL} - PGADMIN_DEFAULT_PASSWORD=${PGADMIN_DEFAULT_PASSWORD} - PGADMIN_CONFIG_SERVER_MODE:${PGADMIN_CONFIG_SERVER_MODE} networks: - postgis_network volumes: - pgadmin-data:${PGADIM_DATA_VOLUME} #depends_on: #postgis: #condition: service_healthy cloudbeaver: image: dbeaver/cloudbeaver:23.1.0 container_name: cloudbeaver_container restart: always ports: - "8085:8978" volumes: - cloudbeaver-data:/opt/cloudbeaver/workspace networks: - postgis_network volumes: postgis-data: pgadmin-data: cloudbeaver-data: networks: postgis_network: driver: bridge
.env 文件配置
POSTGIS_VERSION_TAG=15-3.3 POSTGRES_USER=admin POSTGRES_PASS=password POSTGRES_DB=elevation POSTGRES_ALLOW_IP_RANGE=0.0.0.0/0 POSTGRES_MULTIPLE_EXTENSIONS=postgis,hstore,postgis_topology,postgis_raster,pgrouting POSTGRES_DATA_VOLUME=/var/lib/postgresql PGADIM_VERION_TAG=6.14 PGADIM_CONTAINER_NAME=pgadmin4_container PGADMIN_DEFAULT_EMAIL=admin@admin.com PGADMIN_DEFAULT_PASSWORD=admin PGADMIN_CONFIG_SERVER_MODE=False PGADMIN_PORT=5050 PGADIM_DATA_VOLUME=/var/lib/pgadmin
问题现状
目前我仅能通过pgadmin4连接容器内的PostgreSQL数据库,但使用CloudBeaver等其他工具尝试相同连接操作时均失败,报错信息如下:


恳请各位提供有效的解决方案。
内容的提问来源于stack exchange,提问作者Gianni Spear
相关产品推荐
相关产品推荐

