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?
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 |