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