Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id C8EB7475ADE
	for <pgsql-general@postgresql.org>;
	Wed, 20 Nov 2002 17:12:05 -0500 (EST)
Received: from bob.samurai.com (bob.samurai.com [205.207.28.75])
	by postgresql.org (Postfix) with ESMTP id E8E7C4758FE
	for <pgsql-general@postgresql.org>;
	Wed, 20 Nov 2002 17:12:03 -0500 (EST)
Received: from tokyo.samurai.com (DU150.N224.ResNet.QueensU.CA
	[130.15.224.150]) by bob.samurai.com (Postfix) with ESMTP
	id B981E1E18; Wed, 20 Nov 2002 17:12:02 -0500 (EST)
To: Oliver Elphick <olly@lfix.co.uk>
Cc: Francisco Reyes <lists@natserv.com>,
	pgsql General List <pgsql-general@postgresql.org>
Subject: Re: Closing inactive connections OR user connections limits
References: <20021120133345.A30106-100000@zoraida.natserv.net>
	<878yzo5bqs.fsf@mailbox.samurai.com> <1037829742.24840.34.camel@linda>
From: Neil Conway <neilc@samurai.com>
In-Reply-To: <1037829742.24840.34.camel@linda>
Date: 20 Nov 2002 17:11:58 -0500
Message-ID: <87r8df51sh.fsf@mailbox.samurai.com>
Lines: 22
User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200211/873
X-Sequence-Number: 33294

--=-=-=

Oliver Elphick <olly@lfix.co.uk> writes:
> On Wed, 2002-11-20 at 18:36, Neil Conway wrote:
> > +         The default value is 2. This must be at least as large as the
> > +         value of <varname>max_connections</varname>. This parameter
> 
> At least as large?

Woops :-) You're completely correct, of course.

New version of the patch is attached (another copy sent to -patches
separately).

Thanks for spotting my mistakes, Oliver!

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC

--=-=-=
Content-Type: text/x-patch
Content-Disposition: attachment; filename=reserved_conn_docs-2.patch

Index: doc/src/sgml/runtime.sgml
===================================================================
RCS file: /var/lib/cvs/pgsql-server/doc/src/sgml/runtime.sgml,v
retrieving revision 1.156
diff -c -r1.156 runtime.sgml
*** doc/src/sgml/runtime.sgml	15 Nov 2002 03:22:30 -0000	1.156
--- doc/src/sgml/runtime.sgml	20 Nov 2002 22:08:12 -0000
***************
*** 1642,1647 ****
--- 1642,1670 ----
       </varlistentry>
  
       <varlistentry>
+       <term><varname>SUPERUSER_RESERVED_CONNECTIONS</varname>
+       (<type>integer</type>)</term>
+       <listitem>
+        <para>
+         Determines the number of <quote>connection slots</quote> that
+         are reserved for connections by the <productname>PostgreSQL</>
+         superuser. The maximum number of concurrent connections that
+         can be made from all user accounts combined is
+         <varname>max_connections</> minus
+         <varname>superuser_reserved_connections</varname>; beyond that
+         point, any additional connections from non-superuser accounts
+         are refused.
+        </para>
+ 
+        <para>
+         The default value is 2. This must be less than the value of
+         <varname>max_connections</varname>. This parameter can only be
+         set at server start.
+        </para>
+       </listitem>
+      </varlistentry>
+ 
+      <varlistentry>
        <term><varname>MAX_EXPR_DEPTH</varname> (<type>integer</type>)</term>
        <listitem>
         <para>
***************
*** 2941,2964 ****
    </para>
  
    <para>
!    With SSL support compiled in, the <productname>PostgreSQL</> server
!    can be started with SSL support by setting the parameter
!    <varname>ssl</varname> to on in
!    <filename>postgresql.conf</filename>. When starting in SSL mode,
!    the server will look for the files <filename>server.key</> and
!    <filename>server.crt</> in the data directory.  These files should
!    contain the server private key and certificate respectively. These
!    files must be set up correctly before an SSL-enabled server can
!    start. If the private key is protected with a passphrase, the
!    server will prompt for the passphrase and will not start until it
!    has been entered.
    </para>
  
    <para>
!    The server will listen for both standard and SSL connections on the
!    same TCP/IP port, and will negotiate with any connecting client on
!    whether to use SSL. See <xref linkend="client-authentication"> about
!    how to force the server to only use of SSL for certain connections.
    </para>
  
    <para>
--- 2964,2988 ----
    </para>
  
    <para>
!    With <acronym>SSL</> support compiled in, the
!    <productname>PostgreSQL</> server can be started with
!    <acronym>SSL</> support by setting the parameter
!    <varname>ssl</varname> to on in <filename>postgresql.conf</>. When
!    starting in <acronym>SSL</> mode, the server will look for the
!    files <filename>server.key</> and <filename>server.crt</> in the
!    data directory.  These files should contain the server private key
!    and certificate respectively. These files must be set up correctly
!    before an <acronym>SSL</>-enabled server can start. If the private key is
!    protected with a passphrase, the server will prompt for the
!    passphrase and will not start until it has been entered.
    </para>
  
    <para>
!    The server will listen for both standard and <acronym>SSL</>
!    connections on the same TCP/IP port, and will negotiate with any
!    connecting client on whether to use <acronym>SSL</>. See <xref
!    linkend="client-authentication"> about how to force the server to
!    only use of <acronym>SSL</> for certain connections.
    </para>
  
    <para>

--=-=-=--