Re: BUG #7631: tcp_keepalives_* parameters ignored in postgresql.conf - related to 9.0.10 or 9.0.9 patch? - Mailing list pgsql-bugs

From Rob Johnson
Subject Re: BUG #7631: tcp_keepalives_* parameters ignored in postgresql.conf - related to 9.0.10 or 9.0.9 patch?
Date
Msg-id A5D03C8F7DFDCB4393CE3CF936B42EDB65CA4092@htmail10.hightouchinc.com
Whole thread Raw
In response to Re: BUG #7631: tcp_keepalives_* parameters ignored in postgresql.conf - related to 9.0.10 or 9.0.9 patch?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
>=20
> robj@hightouchinc.com writes:
> > The last four lines in my postgresql.conf file, under
> > /var/lib/pgsql/9.0/data, are:
>=20
> > # (15 per hour * 6 hours =3D 90)
> > tcp_keepalives_count=3D90
> > tcp_keepalives_idle=3D240
> > tcp_keepalives_interval=3D240
>=20
> > 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.
>=20
> I believe those will read as zero in a session connected over a Unix
> socket.  Try it in a session connected over TCP ...
>=20
>             regards, tom lane

You are correct.  In a TCP session, I see the values that were set in postg=
resql.conf.
Thank you for the quick answer.

"This message may contain confidential and/or privileged
information. If you are not the addressee or authorized to
receive this for the addressee, you must not use, copy,
disclose, or take any action based on this message or any
information herein. If you have received this message in error,
please advise the sender immediately by reply e-mail and delete
this message. Thank you for your cooperation."

pgsql-bugs by date:

Previous
From: John R Pierce
Date:
Subject: Re: BUG #7632: Postgres binds to all IPs even when listen_addresses="localhost"
Next
From: abaile33@aol.com
Date:
Subject: BUG #7633: postgres92-9.2.1-1.x86_64 requires libuuid.so.16()(64bit)