On Sun, January 13, 2008 6:53 pm, henry wrote:
> On Sun, January 13, 2008 7:25 pm, Tom Lane wrote:
>> 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.
WRT the origional question: why is tcp_keepalives_idle being ignored
(whether with SET or in postgresql.conf)? - ie, SHOW ALL says it's 0 no
matter what I do.
Regards
Henry