On Fri, Mar 7, 2014 at 10:03:42PM -0500, Bruce Momjian wrote: > On Thu, Nov 14, 2013 at 11:32:23AM +0100, Marko Tiikkaja wrote: > > On 11/14/13 7:08 AM, Tatsuo Ishii wrote: > > >>It means "the connection is idle except for keepalive packets". > > >>We could perhaps just drop the word "otherwise", if people find > > >>it confusing. > > > > > >Wah. I seemed to completely misunderstand what the pharase > > >says. Thanks for clarification. I agree to drop "otherwise". > > > > I had some problem interpreting these explanations as well: > > http://www.postgresql.org/message-id/527a21f1.2000...@joh.to > > > > Compare that to the description in the libpq documentation: > > "Controls the number of seconds of inactivity after which TCP should > > send a keepalive message to the server.". > > Good point. I have improved the server-side keepalive parameter > descriptions to use the superior libpq text, with adjustment. > > Applied patch attached.
Oops, now attached. -- Bruce Momjian <br...@momjian.us> http://momjian.us EnterpriseDB http://enterprisedb.com + Everyone has their own god. +
diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml new file mode 100644 index 86dbd0f..2811f11 *** a/doc/src/sgml/config.sgml --- b/doc/src/sgml/config.sgml *************** include 'filename' *** 684,691 **** </indexterm> <listitem> <para> ! Specifies the number of seconds before sending a keepalive packet on ! an otherwise idle connection. A value of 0 uses the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPIDLE</> or <symbol>TCP_KEEPALIVE</> symbols, and on Windows; on other systems, it must be zero. --- 684,692 ---- </indexterm> <listitem> <para> ! Specifies the number of seconds of inactivity after which TCP ! should send a keepalive message to the client. A value of 0 uses ! the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPIDLE</> or <symbol>TCP_KEEPALIVE</> symbols, and on Windows; on other systems, it must be zero. *************** include 'filename' *** 708,715 **** </indexterm> <listitem> <para> ! Specifies the number of seconds between sending keepalives on an ! otherwise idle connection. A value of 0 uses the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPINTVL</> symbol, and on Windows; on other systems, it must be zero. --- 709,717 ---- </indexterm> <listitem> <para> ! Specifies the number of seconds after which a TCP keepalive message ! that is not acknowledged by the client should be retransmitted. ! A value of 0 uses the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPINTVL</> symbol, and on Windows; on other systems, it must be zero. *************** include 'filename' *** 732,739 **** </indexterm> <listitem> <para> ! Specifies the number of keepalive packets to send on an otherwise idle ! connection. A value of 0 uses the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPCNT</> symbol; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is --- 734,742 ---- </indexterm> <listitem> <para> ! Specifies the number of TCP keepalives that can be lost before ! the server's connection to the client is considered dead. A value of 0 ! uses the system default. This parameter is supported only on systems that support the <symbol>TCP_KEEPCNT</> symbol; on other systems, it must be zero. In sessions connected via a Unix-domain socket, this parameter is
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers