使用docker镜像搭建集群,主节点已经启动,但是备用机器上启动容器时一致在Waiting for primary node
docker-compose配置文件如下
version: "2"
networks:
postgres-network:
driver: bridge
services:
pg-0:
image: bitnami/postgresql-repmgr:latest
ports:
- 54320:5432
container_name: pg-0
volumes:
- /data/pgtest/data:/bitnami/postgresql
networks:
- postgres-network
environment:
- POSTGRESQL_POSTGRES_PASSWORD=bianque@0330
- POSTGRESQL_USERNAME=postgres
- POSTGRESQL_PASSWORD=bianque@0330
- REPMGR_PASSWORD=bianque@0330
- REPMGR_PRIMARY_HOST=pg-1
- REPMGR_PARTNER_NODES=pg-0,pg-1
- REPMGR_NODE_NAME=pg-0
- REPMGR_NODE_NETWORK_NAME=pg-0
- REPMGR_PGHBA_TRUST_ALL=yes # 加上这个配置
pg-1:
image: bitnami/postgresql-repmgr:latest
ports:
- 54321:5432
container_name: pg-1
volumes:
- /data/pgtest/data:/bitnami/postgresql
networks:
- postgres-network
environment:
- POSTGRESQL_POSTGRES_PASSWORD=bianque@0330
- POSTGRESQL_USERNAME=postgres
- POSTGRESQL_PASSWORD=bianque@0330
- REPMGR_PASSWORD=bianque@0330
- REPMGR_PRIMARY_HOST=pg-1
- REPMGR_PARTNER_NODES=pg-0,pg-1
- REPMGR_NODE_NAME=pg-1
- REPMGR_NODE_NETWORK_NAME=pg-1
- REPMGR_PGHBA_TRUST_ALL=yes # 加上这个配置
pgpool:
image: bitnami/pgpool:latest
ports:
- 9999:5432
environment:
- PGPOOL_BACKEND_NODES=0:pg-0:5432,1:pg-1:5432
- PGPOOL_SR_CHECK_USER=repmgr
- PGPOOL_SR_CHECK_PASSWORD=bianque@0330
- PGPOOL_ENABLE_LDAP=no
- PGPOOL_POSTGRES_USERNAME=postgres
- PGPOOL_POSTGRES_PASSWORD=bianque@0330
- PGPOOL_ADMIN_USERNAME=admin
- PGPOOL_ADMIN_PASSWORD=bianque@0330
healthcheck:
test: ["CMD", "/opt/bitnami/scripts/pgpool/healthcheck.sh"]
interval: 10s
timeout: 5s
retries: 5