From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | henry <henry(at)zen(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: tcp_keepalives_idle ignored |
Date: | 2008-01-13 17:25:47 |
Message-ID: | 6129.1200245147@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Martijn van Oosterhout <kleptog(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-01-13 17:33:28 | Re: How to safely compare transaction id? |
Previous Message | Lew | 2008-01-13 17:04:29 | Re: 8.2.4 serious slowdown |