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 VitaleGodfrin, 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.
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.
Hello Team, How can we limit the user to make a specific number of connections to the database?
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных