Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with theSHOW command. - Mailing list 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@fetter.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