public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rıdvan Korkmaz <[email protected]>
To: [email protected]
Subject: pg_file_settings
Date: Mon, 25 Dec 2023 14:37:27 +0300
Message-ID: <CAK30z9TaZG5KnYrs8uBLoUo74i-eVasfHVmUenaj-LtooBrdiA@mail.gmail.com> (raw)

Hi,
When I read the docs for pg_file_settings view on pg_file_settings
<https://www.postgresql.org/docs/current/view-pg-file-settings.html;

.... This view is helpful for checking whether planned changes in the
configuration files will work, or for diagnosing a previous failure. Note
that this view reports on the current contents of the files, not on what
was last applied by the server. (The pg_settings view is usually sufficient
to determine that.)

But the following test shows the opposite. When the parameter value is "on"
for *log_connections, *there is *no error for value*, which is the expected
case. But If I change the value in postgresql.conf to *"dummy"* then re-run
the query, this time *I expected the error column to show error*,* but
again it is null, *which means, I potentially apply this value to the
parameter.

Is there something I am missing?

Client and server is 16.1 from the RPM package.

[image: image.png]


Attachments:

  [image/png] image.png (38.9K, 3-image.png)
  download | view image

view thread (2+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pg_file_settings
  In-Reply-To: <CAK30z9TaZG5KnYrs8uBLoUo74i-eVasfHVmUenaj-LtooBrdiA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox