From: | David Fetter <david(at)fetter(dot)org> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, "Robertson, Alan L" <Alan(dot)Robertson(at)charter(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-27 16:19:17 |
Message-ID: | 20171227161916.GD32234@fetter.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Wed, Dec 27, 2017 at 09:13:38AM -0700, David G. Johnston wrote:
> On Wed, Dec 27, 2017 at 9:05 AM, David Fetter <david(at)fetter(dot)org> wrote:
>
> >
> > The following hack works for me. Apart from being ugly, it's
> > fundamentally unsatisfactory because the question of whether the
> > setting has been activated is left unsettled
> >
>
> Starting with 9.5 we've at least made the parsing of the configuration file
> unnecessary:
>
> https://www.postgresql.org/docs/10/static/view-pg-file-settings.html
Great! That awful query turns into:
SELECT setting
FROM pg_file_settings
WHERE
"name" = 'tcp_keepalives_idle' AND
applied;
...which is a real improvement.
Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2017-12-27 17:11:22 | BUG #14992: Programador Java |
Previous Message | David G. Johnston | 2017-12-27 16:13:38 | Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command. |