Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
or, in other words, is it possible to do this:
[databases]
db1 = user=usr1 pool_size=10 application_name=app1 dbname=data1 ...
db1 = user=usr2 pool_size=20 application_name=app2 dbname=data1 ...
such that when usr1 attempts to connect to db1, they have pool_size of 10 while usr2 attempting to connect to same pool has 20?
That won't work for at least two reasons. The two rows are keyed alike, so only the 2nd will take affect. And those lines are not testing what the user is, they are commanding what the user will be. So connections coming in to pgbouncer for 'db1' will go to the real database as user 'usr2' (regardless of the specified incoming user) and as dbname 'data1'
To do what you seem to want, you would need something like:
[databases]
db1 = dbname=data1
[users]
usr1 = max_user_connections=10
usr2 = max_user_connections=20
[users] and wondering how hard it would be to add some more into the code. Here at least the user name is different so you should be able to distinguish that way.