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,
How can we limit the user to make a specific number of connections to the database?
Just specify this in the db definition configuration :
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.