I am attaching my .ini file , help where I need to change .
The Goal is to limit the number of connections from a specific app - when the db name is db1 and user is user1, only 55 connections are allowed (max_db_connections).
The point with pgbouncer is to map N user connections to n DB connections where N >> n. So pgbouncer will allow up to max_client_conn in total, but every user (user1) will have max 2 real DB connections to this pgbouncer db (db1). Makes sense?
I have tried by setting the below entry under the users section but still I am able to make more than 2 connections. Please suggest what I am missing here ?