PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

The steps necessary here are refreshingly short. Simply follow along:

1. To install in a Debian- or Ubuntu-based system, execute this command:

sudo apt-get install pgbouncer

2. To install in a Red Hat, CentOS, Fedora, or another RHEL-based system, execute this command:

sudo yum install pgbouncer

3. Optionally, make the configuration directory owned by the postgres system user:

sudo chown postgres:postgres /etc/pgbouncer

4. Create a pgbouncer user in our primary PostgreSQL server with this SQL:

CREATE USER pgbouncer WITH PASSWORD 'whatever'; 

5. If it isn't already, add the service to system startup and shutdown:

sudo systemctl enable pgbouncer