Re: Connection limit and Superuser

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

max_connections (integer)              Determines the maximum number of concurrent connections to the       database
server.The default is typically 100, but may be less       if your kernel settings will not support it (as determined
   during initdb). This parameter can only be set at server start.               Increasing this parameter may cause
PostgreSQLto request more       System V shared memory or semaphores than your operating       system's default
configurationallows. See Section 16.4.1 for       information on how to adjust those parameters, if necessary.
    
 
superuser_reserved_connections (integer)              Determines the number of connection "slots" that are reserved
 for connections by PostgreSQL superusers. At most       max_connections connections can ever be active simultaneously.
     Whenever the number of active concurrent connections is at least       max_connections minus
superuser_reserved_connections,new       connections will be accepted only for superusers.               The default
valueis 2. The value must be less than the value of       max_connections. This parameter can only be set at server
start.      
 

Cheers,
Csaba.