has anyone played with/tested this in v7.0? I'm investigating the hanging
problem, and it just happened ... when I do an lsof on the process, it
shows these two:
postgres 4969 pgsql 5u IPv4 0xd4631500 0t0 TCP pgsql.tht.net:5432->smaug.vex.net:61189 (ESTABLISHED)
postgres 4969 pgsql 8u IPv4 0xd46300c0 0t0 TCP pgsql.tht.net:1046->smaug.vex.net:auth (ESTABLISHED)
it doesn't appear to lock it up every time though ... this time it
*eventually* came back again, but, afterwards, if you do another lsof,
there is one more line with that "can't read inpcb..." error on it ...
i pg_hba.conf, that host has:
host trends_acctng 216.126.72.30 255.255.255.255 ident sameuser
And its the only time we have ident being used ...
right now, its the only theory I ahve to work with ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy@hub.org secondary: scrappy@{freebsd|postgresql}.org