jonhartley/kubernetes-pg-pgpool repository overview

⁠PostreSQL PGPool II

⁠Basic Info

• PostgreSQL PGPoolII setup required repmgr to actually carry out failover - see jonhartley/kubernetes-pg-repmgr

⁠ENV Variables

• POSTGRES_DB="book"

• POSTGRES_USER="book"

• POSTGRES_PASSWORD="pass"

• REPLICATION_DB="repmgr"

• REPLICATION_USER="repmgr"

• REPLICATION_PASSWORD="repmgr"

• PCP_USER="pcp_user"

• PCP_PASSWORD="pcp"

• HOSTLIST="pg-0.serv,pg-1.serv,pg-2.serv"

• It should run in Docker so you can test config - use naming conventions as if it was in a Kubernetes Stateful Set - (--hostname=[stateful set name]-[<]pod number].[stateful set service name])

docker network create pg

docker build --rm -t local/kubernetes-pg-pgpool .
docker run --net=pg --name=pgpool --hostname=pgpool \
-e POSTGRES_USER=book -e POSTGRES_PASSWORD=pass \
-e REPLICATION_USER=repmgr -e REPLICATION_PASSWORD=repmgr \
-e HOSTLIST="pg-0.serv,pg-1.serv,pg-2.serv" \
-p 5432:5432 -d local/kubernetes-pg-pgpool

... add in pg-0.serv pg-1.serv pg-2.serv using jonhartley/kubernetes-pg-repmgr 

⁠Kubernetes

• Below is setup for openstack with cinder PVs, small configuration, it can be scaled easily, always go with odd numbers for quoram, includes telegraf container for monitoring and full SSL + backup volume on NFS

TBC