PostgreSQL 11 Administration Cookbook

How to do it…

Each database is completely identified by its connection string. PgBouncer will read this information from its configuration file. Just follow these steps:

1. All you need to do is to set up PgBouncer like you did in the previous recipe, by replacing the databases section of pgbouncer.ini with the following:

[databases] myfirstdb = port=5432 host=localhost anotherdb = port=5437 host=localhost sparedb = port=5435 host=localhost

2. Once you have started PgBouncer, you can connect to the first database:

$ psql -p 6432 -h 127.0.0.1 -U postgres myfirstdbpsql (11.1)Type "help" for help.myfirstdb=# show port;port ------5432(1 row)myfirstdb=# show server_version;server_version ----------------11.1(1 row)

3. Now, you can connect to the ...