O'Reilly logo

PostgreSQL High Performance Cookbook by Dinesh Kumar, Chitij Chauhan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing PgBouncer

PgBouncer provides an administrative console to view pool status and client connections. In this recipe we are going to see information regarding PgBouncer connections, client connections, view pool status, and obtaining connection pooling statistics.

Getting ready

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

Once this is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required