gcavalcante8808/pgbouncer repository overview

⁠Docker-PGBouncer

This is an alpine with PGBouncer installed and a bash entrypoint script that write pgbouncer.ini and userlist.txt(auth plain) files.

⁠Usage

You need to provide the following envinronment variables:

• DB_HOST: address of the target postgres database server;
• DB_NAME: name of the target database;
• DB_USER: user with privileges in the given database;
• DB_PASSWORD: password of the user.

The following env vars are optional but often used:

• CONNECTION_OPTIONS: Default options for connection, separated by whitespace.
• IGNORE_STARTUP_OPTIONS: Options to be ignored, separated by whitespace.. See http://manpages.ubuntu.com/manpages/trusty/man5/pgbouncer.5.html⁠.

WARNING: Invalid connection options will make the pgbouncer to ignore the database entirelly.

The pgbouncer is configured to operate in session and a have an envinronment variabled called MAX_CLIENT_CONN, with the default value 100; define the variable to change the value in pgbouncer.ini.

You can see an full docker-compose example [Here⁠].

The container listens on 5432 by default and use the same name of the DB_NAME env variable for the database.

⁠Author

Author: Gabriel Abdalla Cavalcante Silva ([email protected]⁠)