> On Sep 20, 2022, at 10:03 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > > 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 I was afraid you would conclude that. But its just plain ol’ psql (inside emacs) on interactive node directly to db server node, all in a “protected environment”. There could be network pieces in the middle that are getting uppity. I’ll ask /them/. Thanks
