Re: tcp settings

> On Sep 20, 2022, at 10:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Rob Sargent <robjsargent@gmail.com> 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
servernode, all in a “protected environment”.  There could be network pieces in the middle that are getting uppity.
I’llask /them/. 

Thanks