Configuring your first pgbouncer setup

Once we have compiled and installed pgbouncer, we can easily fire it up. To do so we have set up two databases on a local instance (p0 and p1). The idea of the setup performed in this example is to use pgbouncer as a proxy.

Writing a simple config file and starting pgbouncer up

In order to make pgbouncer work we can write a simple config file, which can be fed to pgbouncer:

[databases] p0 = host=localhost dbname=p0 p1 = host=localhost dbname=p1 [pgbouncer] logfile = /var/log/pgbouncer.log pidfile = /var/log/pgbouncer.pid listen_addr = 127.0.0.1 listen_port = 6432 auth_type = trust auth_file = /etc/pgbouncer/userlist.txt pool_mode = session server_reset_query = DISCARD ALL max_client_conn = 100 default_pool_size ...

Get PostgreSQL Replication now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.