tcp_keepalive values not taking

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: tcp_keepalive values not taking
Date: 2007-08-20 15:53:22
Message-ID: cone.1187625202.967802.1017.5001@35st.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Edson 2007-08-20 16:19:14 Stripping apostrophes from data
Previous Message Robert Gravsjö 2007-08-20 15:09:11 Re: Table description