Обсуждение: max connections per user

Поиск
Список
Период
Сортировка

max connections per user

От
beluc.mailing@free.fr
Дата:
hi,

i would like to know if it is possible to limit the number of connections per
user.

if postgresql.conf, i just see a "max connections" parameter but it's a global
parameter.

i think i can do this using iptables, but i would be more convenient to do this
in pg.

Re: max connections per user

От
Carol Walter
Дата:
Yes, you can use the connection limit parameter when you create or
alter a user.

Carol
On Nov 12, 2007, at 10:39 AM, beluc.mailing@free.fr wrote:

> hi,
>
> i would like to know if it is possible to limit the number of
> connections per
> user.
>
> if postgresql.conf, i just see a "max connections" parameter but
> it's a global
> parameter.
>
> i think i can do this using iptables, but i would be more
> convenient to do this
> in pg.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend