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, ...
Get PostgreSQL Replication - Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
