Re: max connections per user

From: Carol Walter <walterc(at)indiana(dot)edu>
To: beluc(dot)mailing(at)free(dot)fr
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: max connections per user
Date: 2007-11-12 16:09:09
Message-ID: 7FD4D575-D76C-4A6C-89AC-0A43271DD36F@indiana.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)mailing(at)free(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2007-11-12 16:47:53 Re: HELP: I removed file pg_log, how can I recover?
Previous Message beluc.mailing 2007-11-12 15:39:25 max connections per user