Re: Lost connections - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Lost connections
Date
Msg-id 20030130145656.N983@mail.libertyrms.com
Whole thread Raw
In response to Lost connections  ("Donald Fraser" <demolish@cwgsy.net>)
List pgsql-admin
On Thu, Jan 30, 2003 at 07:10:47PM -0000, Donald Fraser wrote:
> 1) How as an administrator can I tell which connections are lost
> and which are not so I can shut down the appropriate processes?

The dead connection should get cleaned up when the TCP timeout
happens, as I understand it.

> 2) Is there a way of connecting to the server with client
> applications that can avoid this situation. That is can the client
> software do something extra when connecting such as additional
> parameters, keep alive socket options... to avoid this scenario?

Not as far as I know.  You could lower your TCP timeout, I guess, but
I believe the TCP/IP authorities say this is a Bad Idea.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-admin by date:

Previous
From: Oliver Vecernik
Date:
Subject: Re: Making connections to postgres under FreeBSD
Next
From: Len Conrad
Date:
Subject: Fwd: Postfix SMTP server: errors from relay2.pgsql.com[64.49.215.143]