back to downloads

pgPool

A connection load balancer with pooling and other capabilities

4.7.0
linux
amd64
View pgPool documentation

Step 1

Create a network so that the PostgreSQL and pgpool containers can communicate with each other:

docker network create --driver bridge pgnetwork

Step 2

Set up key environmental variables for working with both of the containers. This creates a user named hippo with a password of datalake that has access to a database named hippo:

cat << EOF > postgres-env.list
PG_MODE=primary
PG_PRIMARY_USER=postgres
PG_PRIMARY_PASSWORD=datalake
PG_DATABASE=hippo
PG_USER=hippo
PG_PASSWORD=datalake
PG_ROOT_PASSWORD=datalake
PG_PRIMARY_PORT=5432
EOF

cat << EOF > pgpool-env.list
PG_PRIMARY_SERVICE_NAME=postgres
PG_REPLICA_SERVICE_NAME=postgres
PG_USERNAME=hippo
PG_PASSWORD=datalake
PG_DATABASE=postgres
EOF

Step 3

Run the containers container:

docker run --publish 5432:5432 \
  --volume=postgres:/pgdata \
  --env-file=postgres-env.list \
  --name="postgres" \
  --hostname="postgres" \
  --network="pgnetwork" \
  --detach \
registry.developers.crunchydata.com/crunchydata/crunchy-postgres:centos8-13.3-4.7.0

docker run --publish 11000:5432 \
  --env-file=pgpool-env.list \
  --name="pgpool" \
  --hostname="pgpool" \
  --network="pgnetwork" \
  --detach \
registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.3-4.7.0

Step 4

Log into the PostgreSQL cluster via pgPool:

PGPASSWORD=datalake psql -h localhost -p 11000 -U hippo hippo
TAGS:

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.7-4.7.0
COMPRESSED SIZE: 584.81 MB

4.7.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.3-4.7.0
COMPRESSED SIZE: 584.81 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.3-4.6.3
COMPRESSED SIZE: 509.21 MB

4.6.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.7-4.6.3
COMPRESSED SIZE: 509.21 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.2-4.6.2
COMPRESSED SIZE: 484.05 MB

4.6.2

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.6-4.6.2
COMPRESSED SIZE: 484.05 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.6-4.6.1
COMPRESSED SIZE: 477.13 MB

4.6.1

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.2-4.6.1
COMPRESSED SIZE: 477.13 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.1-4.6.0
COMPRESSED SIZE: 476.97 MB

4.6.0

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.5-4.6.0
COMPRESSED SIZE: 476.97 MB

4.5.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-13.3-4.5.3
COMPRESSED SIZE: 528.58 MB

4.5.3

docker pull registry.developers.crunchydata.com/crunchydata/crunchy-pgpool:centos8-12.7-4.5.3
COMPRESSED SIZE: 528.58 MB