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.
|
