"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