I'll be asking 'those in charge' to reset some timeout/keep-alive setting /somewhere/. I need help in hopefully naming the correct setting. The server is running version 14
Am I dealing with a client issue, a server issue or a mis-match in host/postgres configuration values? If I cannot have psql wait forever, I would at least like it to die/reconnect quickly. What are my options?
If I leave my psql session for long enough, then the first interaction (with some exceptions) will be unresponsive for /some time/. The typical, eventual response is a successful re-connection though last one was fatal:
psql:/uufs/chpc.utah.edu/common/HIPAA/u0138544/gits/gitlab/sgs5/jooq/src/main/resources/db/scripts/functions/showSegmentCalls.sql:22: SSL SYSCALL error: Connection timed out psql:/uufs/chpc.utah.edu/common/HIPAA/u0138544/gits/gitlab/sgs5/jooq/src/main/resources/db/scripts/functions/showSegmentCalls.sql:23: no connection to the server psql:/uufs/chpc.utah.edu/common/HIPAA/u0138544/gits/gitlab/sgs5/jooq/src/main/resources/db/scripts/functions/showSegmentCalls.sql:23: fatal: connection to server was lost
More typically I get this
barnard=# select 1; C-c C-cCancel request sent SSL SYSCALL error: Connection timed out barnard=# \c barnard psql (12.2, server 14.2) WARNING: psql major version 12, server major version 14. Some psql features might not work. SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES128-GCM-SHA256, bits: 128, compression: off) You are now connected to database "barnard" as user "postgres".
the dbhost postgresql.conf has tcp_* set to zero (use default)
#tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; # 0 selects the system default #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; # 0 selects the system default #tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system default #tcp_user_timeout = 0 # TCP_USER_TIMEOUT, in milliseconds; # 0 selects the system default
#client_connection_check_interval = 0 # time between checks for client # disconnection while running queries; # 0 for never [postgres@csgsdb ipv4]$ for t in tcp_keep*;do printf "%s: " $t; cat $t; done tcp_keepalive_intvl: 75 tcp_keepalive_probes: 9 tcp_keepalive_time: 7200