Re: BUG #13441: pg_settings.pending_restart cann't reflect changed setting in configure file.

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: digoal(at)126(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13441: pg_settings.pending_restart cann't reflect changed setting in configure file.
Date: 2015-06-14 22:41:09
Message-ID: CAB7nPqQtfPNeEWJps+ZT42UqncdW18wrfvZ7KPqASNqtjtp31g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sun, Jun 14, 2015 at 6:26 PM, <digoal(at)126(dot)com> wrote:
> In PostgreSQL 9.5 doc, pg_settings.pending_restart boolean true if the value
> has been changed in the configuration file but needs a restart; or false
> otherwise.
> BUT, when i change the configure file, by alter system , or modify it direct
> in postgresql.conf.
> the value cann't reflect by pg_settings.

You need to reload parameters on server to make those changes visible.
This feature behaves as designed as far as I know. So we don't have
any bug here.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Gradek 2015-06-15 04:02:28 Re: BUG #13440: unaccent does not remove all diacritics
Previous Message Tom Lane 2015-06-14 17:59:18 Re: BUG #13440: unaccent does not remove all diacritics