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

Re: Connection limit and Superuser

From: Rod Taylor <pg(at)rbt(dot)ca>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Connection limit and Superuser
Date: 2006-07-31 13:28:10
Message-ID: 1154352490.24186.303.camel@home (view raw or flat)
Thread:
Lists: 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.

-- 


In response to

pgsql-hackers by date

Next:From: Rod TaylorDate: 2006-07-31 13:31:49
Subject: Re: Connection limit and Superuser
Previous:From: Michael MeskesDate: 2006-07-31 13:27:34
Subject: Re: [COMMITTERS] pgsql: First small patches needed for regression tests

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