The following bug has been logged on the website: Bug reference: 7631 Logged by: Rob Johnson Email address: r...@hightouchinc.com PostgreSQL version: 9.0.10 Operating system: RHEL 5.8 Description:
The last four lines in my postgresql.conf file, under /var/lib/pgsql/9.0/data, are: # (15 per hour * 6 hours = 90) tcp_keepalives_count=90 tcp_keepalives_idle=240 tcp_keepalives_interval=240 I last changed this file on August 13th, 2012. I remember that when I added these parameters to postgresql.conf, they showed the correct values when I ran "show all" at the psql command line. However, they now all display 0 values. I ran "show all" and included some of the output below. The config_file parameter shows that when the instance started, it used the postgresql.conf file that includes my tcp_keepalives_* parameters. The "max_connections" parameter is 600, which I also have defined in that postgresql.conf file, so I know that at least *some* non-default parameter values are processed properly. I *suspect* this problem was created by the 9.0.10 or 9.0.9 patch, because I was running 9.0.8 when I changed the tcp_keepalives_* parameters, but that's just an uninformed guess. (I updated my postgresql* packages from the PGDG repository to 9.0.9 on August 20th, and to 9.0.10 on September 25th.) postgres=# show all; name | setting | description ---------------------------------+-----------------------------------------+--------------------------------------------------------------------------------- ---------------------------------------------- ... config_file | /var/lib/pgsql/9.0/data/postgresql.conf | Sets the server's main configuration file. ... max_connections | 600 | Sets the maximum number of concurrent connections. ... tcp_keepalives_count | 0 | Maximum number of TCP keepalive retransmits. tcp_keepalives_idle | 0 | Time between issuing TCP keepalives. tcp_keepalives_interval | 0 | Time between TCP keepalive retransmits. ... (208 rows) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs