From: | Rob Sargent <robjsargent(at)gmail(dot)com> |
---|---|
To: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | tcp settings |
Date: | 2022-09-20 20:05:46 |
Message-ID: | 58e221af-b764-61ae-6337-a2aa2fead8a2@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 "man tcp" for details
#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
and in the /proc/sys/net/ipv4 I see no "keepalives" plural.
tcp_abort_on_overflow tcp_fastopen_key tcp_min_snd_mss
tcp_slow_start_after_idle
tcp_adv_win_scale tcp_fin_timeout
tcp_min_tso_segs tcp_stdurg
tcp_allowed_congestion_control tcp_frto tcp_moderate_rcvbuf
tcp_synack_retries
tcp_app_win tcp_invalid_ratelimit
tcp_mtu_probing tcp_syncookies
tcp_autocorking tcp_keepalive_intvl(75)
tcp_no_metrics_save tcp_syn_retries
tcp_available_congestion_control tcp_keepalive_probes(9)
tcp_notsent_lowat tcp_thin_dupack
tcp_base_mss tcp_keepalive_time(7200)
tcp_orphan_retries tcp_thin_linear_timeouts
tcp_challenge_ack_limit tcp_limit_output_bytes
tcp_reordering tcp_timestamps
tcp_congestion_control tcp_low_latency
tcp_retrans_collapse tcp_tso_win_divisor
tcp_dsack tcp_max_orphans
tcp_retries1 tcp_tw_recycle
tcp_early_retrans tcp_max_ssthresh
tcp_retries2 tcp_tw_reuse
tcp_ecn tcp_max_syn_backlog
tcp_rfc1337 tcp_window_scaling
tcp_fack tcp_max_tw_buckets
tcp_rmem tcp_wmem
tcp_fastopen tcp_mem tcp_sack
tcp_workaround_signed_windows
My issue is that psql is timing out with "SSL SYSCALL error: Connection
timed out". The TCP defaults for keepalive look fine to me but not what
I'm experiencing. I have PGCONNECT_TIMEOUT=0 in my env for psql.
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2022-09-20 21:08:39 | Experience with Dell SRM/SRDF? |
Previous Message | Ron | 2022-09-20 17:44:57 | Re: PCI-DSS Requirements |