Hello Lukas, You would be able to achieve it using the alter user command as given below: alter user <user name> with CONNECTION LIMIT 2; Lukas wrote:
Hello, is here any way to set connection limit to database per database user? For ex. if I have postgresql database user XXX I want limit it to 2 connections per database (or per all databases).. -- Lukas UAB nSoft http://www.nsoft.lt Lukas at nsoft.lt +370 655 10 655
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin