tcp_keepalive values not taking - Mailing list pgsql-general

From Francisco Reyes
Subject tcp_keepalive values not taking
Date
Msg-id cone.1187625202.967802.1017.5001@35st.simplicato.com
Whole thread Raw
List pgsql-general
Postgresql 8.2.4
FreeBSD 6.2

According to
http://www.postgresql.org/docs/current/static/runtime-config-connection.html
the tcp_keepaliave variables take the OS setting if 0, or use whatever value
one puts in postgresql.conf.

I tried the following values in postgresql.conf:

tcp_keepalives_idle = 600               # TCP_KEEPIDLE, in seconds;
                                        # 0 selects the system default
tcp_keepalives_interval = 60            # TCP_KEEPINTVL, in seconds;
                                        # 0 selects the system default
tcp_keepalives_count = 10               # TCP_KEEPCNT;
                                        # 0 selects the system default

Yet when I do "show tcp_keepalives_idle", "show tcp_keepalives_interval" or
"tcp_keepalives_count" they all show zero. Tried both reload and
restart.

Also tried changing sysctl net.inet.tcp.keepidle=600 in FreeBSD. It still
doesn't show in postgresql.

Any suggestions?

pgsql-general by date:

Previous
From: Robert Gravsjö
Date:
Subject: Re: Table description
Next
From: Andrew Edson
Date:
Subject: Stripping apostrophes from data