Configuring pgbouncer v23
TPA will install and configure pgbouncer on instances whose
By default, pgbouncer listens for connections on port 6432 and forwards
127.0.0.1:5432 (which may be either Postgres or
haproxy, depending on the architecture).
You can set the following variables on any
|The TCP port pgbouncer should listen on
|A Postgres server to connect to
|The port that the
pgbouncer_backend listens on
|The maximum number of connections allowed; the default is derived from the backend's
max_connections setting if possible
|Postgres user to use for authentication
By default, TPA will generate
/etc/pgbouncer/pgbouncer.databases.ini with a single wildcard
[databases] to forward all connections to the backend
server. You can set
pgbouncer_databases as shown in the example below
to change the database configuration.
PgBouncer will connect to Postgres as the
execute the (already configured)
auth_query to authenticate users.