Martijn van Oosterhout <kleptog@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
