crunchy-pgpool
The crunchy-pgpool container executes the pgPool II utility. pgPool can be used to provide a smart PostgreSQL-aware proxy to a PostgreSQL cluster, both primary and replica, so that applications only have to work with a single database connection.
PostgreSQL replicas are read-only whereas a primary is capable of receiving both read and write actions.
The default pgPool examples use a Secret to hold the set of pgPool configuration files used by the examples.
The Secret is mounted into the pgconf volume mount where the container will look to find configuration files.
If you do not specify your own configuration files via a Secret then you can specify environment
variables to the container that it will attempt to use to configure pgPool, although this is not recommended
for production environments. The pgpool container allows for local login with a properly configured password file.
Features
The following features are supported by the crunchy-postgres container:
- Basic invocation of pgPool II
Packages
The crunchy-pgpool Docker image contains the following packages (versions vary depending on PostgreSQL version):
- PostgreSQL (13.4, 12.8, 11.13, 10.18, and 9.6.23)
- pgPool II
- CentOS 7, CentOS 8 - publicly available
- UBI 7, UBI 8 - customers only
Environment Variables
Required
| Name | Default | Description |
|---|---|---|
| PG_USERNAME | None | Username for the PostgreSQL role being used. |
| PG_PASSWORD | None | Password for the PostgreSQL role being used. |
| PG_PRIMARY_SERVICE_NAME | None | Database host to connect to for the primary node. |
| PG_REPLICA_SERVICE_NAME | None | Database host to connect to for the replica node. |
Optional
| Name | Default | Description |
|---|---|---|
| CRUNCHY_DEBUG | FALSE | Set this to true to enable debugging in logs. Note: this mode can reveal secrets in logs. |