Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command.

Is this described in the documentation somewhere?

Is there an alternative way to read out what the system thinks that these TCP-related configuration values are set to?

Thanks!

-- Alan

________________________________________
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Friday, December 22, 2017 10:20 AM
To: Robertson, Alan L
Cc: Postgres Bug
Subject: Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command.

"Robertson, Alan L" <Alan(dot)Robertson(at)charter(dot)com> writes:
> Dear Postgres Bug list,
> I read about the ALTER SYSTEM command at https://www.postgresql.org/docs/9.6/static/sql-altersystem.html and an article at
> http://paquier.xyz/postgresql-2/postgres-9-4-feature-highlight-alter-system-set-for-dynamic-configuration/

> and his example worked exactly as it should. However, when I tried with tcp_keepalives_idle, updates the auto.conf file as it should, but does not show up in the SHOW command... I tried it with the value 60, or '60' - didn't seem to make any difference...

I think the keepalive settings will read as zero unless your connection
is actually over TCP (ie not a unix socket).

regards, tom lane
E-MAIL CONFIDENTIALITY NOTICE:
The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited.