Re: tcp_keepalives_idle ignored - Mailing list pgsql-general

From Tom Lane
Subject Re: tcp_keepalives_idle ignored
Date
Msg-id 6129.1200245147@sss.pgh.pa.us
Whole thread Raw
In response to Re: tcp_keepalives_idle ignored  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: tcp_keepalives_idle ignored  ("henry" <henry@zen.co.za>)
List pgsql-general
Martijn van Oosterhout <kleptog@svana.org> writes:
> On Sun, Jan 13, 2008 at 08:40:34AM +0200, henry wrote:
>> lsof doesn't tell me what's talking to PG through /tmp/.s.PGSQL.5432
>> either.  Maybe I'm not understanding exactly how /tmp/.s.PGSQL.5432 is
>> used - what would connect to PG via a domain socket?

> Connecting to unix domain socket happens if you don't specify a host.

Specifically, a local connection goes through the socket file by
default, and via TCP only if you say "-h localhost" or equivalent.

Now that we know the problem connections are local ones, setting a TCP
timeout would be 100% useless anyway.  As Martijn says, the other ends
of the socket connections *must* be on that box someplace --- I'm
inclined to think that lsof didn't show them to you because you didn't
run it as root and they belong to some other userid.

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Wilson
Date:
Subject: Re: ECPG problem with 8.3
Next
From: Tom Lane
Date:
Subject: Re: How to safely compare transaction id?