May 2018
Intermediate to advanced
576 pages
30h 25m
English
Each database is completely identified by its connection string. PgBouncer will read this information from its configuration file. The steps to be done are as follows:
[databases] myfirstdb = port=5432 host=localhost anotherdb = port=5437 host=localhost sparedb = port=5435 host=localhost
$ psql -p 6432 -h 127.0.0.1 -U postgres myfirstdbpsql (9.6.1)Type "help" for help.myfirstdb=# show port;port ------5432(1 row)myfirstdb=# show server_version;server_version ----------------10.1(1 row)