The pgbouncer utility provides an administrative console to view pool status and client connections. In this recipe, we are going to view information regarding pgbouncer connections (client connections), view pool status, and obtain connection pooling statistics.
Before we issue any commands, we first need to connect to the pgbouncer's administrative console. For this purpose, we need to set the
admin_users parameter in the
pgbouncer.ini configuration file:
vi /etc/pgbouncer/pgbouncer.ini admin_users = author
Once the preceding changes are saved in the
pgbouncer.ini configuration file, the pgbouncer service needs to be restarted in order to ensure that the parameter changes come into effect:
service pgbouncer restart ...