Maintaining PgBouncer
In addition to what we have already described in this chapter, PgBouncer has a nice interactive administration interface capable of performing basic administration and monitoring tasks.
How does it work? PgBouncer provides you with a fake database called pgbouncer. It cannot be used for queries, as it only provides a simple syntax for handling basic administrative tasks.
Tip
If you are using PgBouncer, please don't use a normal database called pgbouncer. It will just amount to confusion and yield zero benefits.
Configuring the admin interface
To configure this interface, we have to adapt our config file. In our example, we will simply add one line to the config (in the PgBouncer section of the file):
admin_users = zb
We want Zoltan, whose username is zb, to be in charge of the admin database, so we simply add him here. If we want many users to get access to the system, we can list them one after another (separated by commas).
After restarting PgBouncer, we can try connecting...
