View Single Post

   
  #7 (permalink)  
Old 04-12-2008, 03:47 AM
Rod Taylor
 
Posts: n/a
Default Re: Connection limit and Superuser

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/s...CTION-SETTINGS


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

--


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply With Quote