pgbouncer-docker

A small Alpine based pgbouncer Docker image

To pull container

docker pull hyperized/pgbouncer

To build container

docker build -t hyperized/pgbouncer .

To run container

docker run -v $(pwd):/m -p 6543:6543 hyperized/pgbouncer /m/example.ini

To run container with TLS to PostgreSQL server

Commonly used with PHP as local connection pool to eliminate TLS overhead.

Expects ca.crt, key.pem and cert.pem to be present in current folder.

See tls.ini for details

docker run -v $(pwd):/m -p 6543:6543 hyperized/pgbouncer /m/tls.ini

Expect output to be like:

2025-01-10 10:37:10.124 UTC [1] LOG kernel file descriptor limit: 1048576 (hard: 1048576); max_client_conn: 100, max expected fd use: 152
2025-01-10 10:37:10.124 UTC [1] LOG listening on 0.0.0.0:6543
2025-01-10 10:37:10.124 UTC [1] LOG listening on unix:/tmp/.s.PGSQL.6543
2025-01-10 10:37:10.124 UTC [1] LOG process up: PgBouncer 1.24.0, libevent 2.1.12-stable (epoll), adns: c-ares 1.34.3, tls: OpenSSL 3.3.2 3 Sep 2024

To log in with this example:

psql -h 127.0.0.1 -p 6543 -U user@secure pgbouncer

with the password mypass (as described in password.txt)

To show stats

psql -h 127.0.0.1 -p 6543 pgbouncer

psql (17.2, server 1.24.0/bouncer)
Type "help" for help.

pgbouncer=# SHOW STATS;

Reference

Docker hub: https://hub.docker.com/r/hyperized/pgbouncer

Github: https://github.com/hyperized/pgbouncer-docker