> On Sep 20, 2022, at 10:03 PM, Tom Lane wrote:
>
> Rob Sargent 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 lef
Rob Sargent 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
>> My issue is that psql is timing out with "SSL SYSCALL error: Connection
>> timed out".
>
> 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
Rob Sargent writes:
> I'm wondering if there's a disconnect between my servers postgresql.conf
> and the system tcp settings? Are the config names supposed to match a
> file in /proc/sys/net/ipv4?
Probably not --- we certainly didn't pick them with the intention
I'm wondering if there's a disconnect between my servers postgresql.conf
and the system tcp settings? Are the config names supposed to match a
file in /proc/sys/net/ipv4?
In postgres 14 install's postgresql.conf on centos 7:
# - TCP settings -
# see "
