PostgreSQL High Availability Cookbook - Second Edition

How to do it...

Presuming that our calculated pool size was 25, with a memory-imposed maximum of 350, follow these steps to properly configure PgBouncer:

1. Execute this query as the postgres user while connected to any database within PostgreSQL:

        COPY ( 
            SELECT '"' || rolname || '" "' ||  
                   coalesce(rolpassword, '') || '"' 
              FROM pg_authid 
        ) 
        TO '/etc/pgbouncer/userlist.txt'; 

2. Open the /etc/pgbouncer/pgbouncer.ini file as the postgres system user.
3. Under the section labeled [databases], create the following entry:

        postgres = host=localhost 

4. Under the section labeled [pgbouncer], find the listen_addr entry and change it to the following:

        listen_addr = * 

5. Under the section labeled [pgbouncer], find the auth_type entry and change it to the following: ...