Re: Connection limit and Superuser - Mailing list pgsql-hackers

From Rod Taylor
Subject Re: Connection limit and Superuser
Date
Msg-id 1154352490.24186.303.camel@home
Whole thread Raw
In response to Re: Connection limit and Superuser  (Csaba Nagy <nagy@ecircle-ag.com>)
List pgsql-hackers
On Mon, 2006-07-31 at 15:07 +0200, Csaba Nagy wrote:
> On Mon, 2006-07-31 at 15:00, Martijn van Oosterhout wrote:
> > On Mon, Jul 31, 2006 at 08:47:38AM -0400, Rod Taylor wrote:
> > > It appears that the superuser does not have connection limit
> > > enforcement. I think this should be changed.
> > 
> > So if some admin process goes awry and uses up all the connection
> > slots, how does the admin get in to see what's happening? If there's a
> > limit you're not really superuser, are you?
> 
> I thought there is a limit for super-users too... citation from:
> http://www.postgresql.org/docs/8.1/static/runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS

Sorry for not being more specific. I was speaking about ALTER ROLE WITH
CONNECTION LIMIT.

-- 



pgsql-hackers by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [COMMITTERS] pgsql: First small patches needed for regression tests
Next
From: Csaba Nagy
Date:
Subject: Re: Connection limit and Superuser