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

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

In response to

Responses

Browse pgsql-bugs by date

  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.