Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Yes, you can use the connection limit parameter when you create or  
alter a user.

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group