To use the PgBouncer Exporter, you will need to connect via a PgBouncer user
with database stats or admin privileges.

To create a PgBouncer user for this, add a new username and password to
/etc/pgbouncer/userlist.txt, such as:

"exporter" "password"

Then give this user stats permissions by adding the following to the
[pgbouncer] section of /etc/pgbouncer/pgbouncer.ini:

stats_users = exporter

Finally, set the connection string in
/etc/default/prometheus-pgbouncer-exporter:

PGBOUNCER_EXPORTER_CONNECTION_STRING='postgres://exporter:password@localhost:6432/pgbouncer?sslmode=disable'


A configuration change to ignore a PostgreSQL driver connection parameter is
also needed. Add the following to the [pgbouncer] section of
/etc/pgbouncer/pgbouncer.ini:

ignore_startup_parameters = extra_float_digits


After making changes, restart the pgbouncer and prometheus-pgbouncer-exporter services.