On Sun, January 13, 2008 6:53 pm, henry wrote: > On Sun, January 13, 2008 7:25 pm, Tom Lane wrote: >> Martijn van Oosterhout <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
