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

Re: Connection limit and Superuser

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Connection limit and Superuser
Date: 2006-07-31 13:00:30
Message-ID: 20060731130030.GB29868@svana.org (view raw or flat)
Thread:
Lists: pgsql-hackers
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?

> Slony in particular does not need more than N connections but does
> require being a super user.

Maybe someone should look into enabling slony to not run as a
superuser?

Have a nice day,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

pgsql-hackers by date

Next:From: Teodor SigaevDate: 2006-07-31 13:04:00
Subject: User-defined typle similar to char(length) varchar(length)
Previous:From: Rod TaylorDate: 2006-07-31 12:47:38
Subject: Connection limit and Superuser

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