[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-bugs
Subject:    Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW command.
From:       "Robertson, Alan L" <Alan.Robertson () charter ! com>
Date:       2017-12-27 18:15:03
Message-ID: 1514398503085.24755 () charter ! com
[Download RAW message or body]

And, in a perfect world, the "passing" config items would be included in database \
backups - in a form that would allow them to automatically be restored along with the \
database... :-D

To me, this makes sense, since your database backups are in the form of SQL that will \
restore the database to its original/current state.

Thoughts?

 -- Alan



________________________________________
From: Robertson, Alan L
Sent: Wednesday, December 27, 2017 10:51 AM
To: David Fetter; David G. Johnston
Cc: Amit Kapila; Tom Lane; Postgres Bug
Subject: Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW \
command.

So, if I understand correctly, this query would yield one row if it was syntactically \
correct, and no rows if it had a syntax error.

And there's nothing which indicates if it is currently activated or not.

Do I understand that correctly?

    Thanks!


________________________________________
From: David Fetter <david@fetter.org>
Sent: Wednesday, December 27, 2017 9:19 AM
To: David G. Johnston
Cc: Amit Kapila; Robertson, Alan L; Tom Lane; Postgres Bug
Subject: Re: ALTER SYSTEM for tcp_keepalives_idle doesn't show up with the SHOW \
command.

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
E-MAIL CONFIDENTIALITY NOTICE: 
The contents of this e-mail message and any attachments are intended solely for the \
addressee(s) and may contain confidential and/or legally privileged information. If \
you are not the intended recipient of this message or if this message has been \
addressed to you in error, please immediately alert the sender by reply e-mail and \
then delete this message and any attachments. If you are not the intended recipient, \
you are notified that any use, dissemination, distribution, copying, or storage of \
this message or any attachment is strictly prohibited.


[prev in list] [next in list] [prev in thread] [next in thread]