Rob Sargent <robjsargent@xxxxxxxxx> writes: >> then keepalives aren't necessarily the solution anyway. When is >> this failure occurring ... is it while trying to establish the >> database connection in the first place? Or does it only happen >> if you've left the psql session sit idle for a long while? > Sitting idle for not even a long while. Under half hour I feel would do it. But I don’t think it times out while I’m “SQLing” OK, that does sound like something that reducing the keepalive interval could help with. The traditional keepalive timeout is a couple of hours, at least on my Linux box: $ cat /proc/sys/net/ipv4/tcp_keepalive_time 7200 but it sounds like there's something between you and the database server that will forget connections a lot quicker than that. regards, tom lane
