psql timeout: who's waiting for whom

[Rob Sargent <robjsargent@xxxxxxxxx>]

    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:
    
> barnard=#
>         \i
> ~/gits/gitlab/sgs5/jooq/src/main/resources/db/scripts/functions/showSegmentCalls.sql
>         
> 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 client machine is using default TCP values, 
    
> tcp_keepalive_intvl: 75
>       tcp_keepalive_probes: 9
>       tcp_keepalive_time: 7200
>       
>     
    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
>         
>       
    Thanks
>       
>