Hi Michael ,
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 ?
[users]
user1 = pool_mode=transaction max_user_connections=2
user1 = pool_mode=transaction max_user_connections=2
Here are my other details:
[databases]
db1 = host=localhost dbname=db1
db1 = host=localhost dbname=db1
logfile = /var/log/pgbouncer/pgbouncer.log
pidfile = /var/run/pgbouncer/pgbouncer.pid
pidfile = /var/run/pgbouncer/pgbouncer.pid
listen_addr = *
listen_port = 6432
listen_port = 6432
auth_type = md5
auth_file = /etc/pgbouncer/userlist.txt
admin_users = postgres
auth_file = /etc/pgbouncer/userlist.txt
admin_users = postgres
pool_mode = session
max_client_conn = 300
max_db_connections = 2
max_user_connections = 2
On Mon, Dec 13, 2021 at 6:38 PM MichaelDBA <MichaelDBA@xxxxxxxxxxx> wrote:
Hi all,
If you add the user to the database specification, then you can limit connections per user:
db1 = host=localhost dbname=db1 pool_size=2 user=myuser
Regards,
Michael Vitale
Godfrin, Philippe E wrote on 12/13/2021 7:57 AM:
On 13/12/21 10:05 π.μ., Daulat wrote:
Hello Team,Just specify this in the db definition configuration :
How can we limit the user to make a specific number of connections to the database?
db1 = host=localhost dbname=db1 pool_size=2
but it will apply to every user, so that every user's pool will have max 2 connections, not only user1.
Alternatively you could set "ALTER ROLE .. CONNECTION LIMIT connlimit " for user1 individually.
