So I have this pgbouncer config:
[databases] my_db = host=10.10.10.10 my_db_with_conn_limit = host=10.10.10.10 dbname=my_db pool_size=55 max_client_conn = 300 default_pool_size = 65 reserve_pool_size = 5 reserve_pool_timeout = 1
And the goal is to limit the number of connections from a specific app - when the db name is database_with_conn_limit, only 55 connections are allowed.
Basically, the apps are identical, but I want one to be limited in connections and the other one grab as many as it wants.
- Is this a correct setup?
- Or should I specify pool_size for my_db, too, giving it all Postgres has minus 55?