| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Robertson, Alan L" <Alan(dot)Robertson(at)charter(dot)com> |
| Cc: | Postgres Bug <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command. |
| Date: | 2017-12-22 17:20:09 |
| Message-ID: | 17247.1513963209@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robertson, Alan L | 2017-12-22 17:46:45 | Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command. |
| Previous Message | Robertson, Alan L | 2017-12-22 16:18:09 | ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command. |