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

Started by 德哥almost 11 years ago2 messagesbugs
Jump to latest
#1德哥
digoal@126.com

The following bug has been logged on the website:

Bug reference: 13441
Logged by: digoal
Email address: digoal@126.com
PostgreSQL version: Unsupported/Unknown
Operating system: centos 6.x x64
Description:

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.

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Michael Paquier
michael@paquier.xyz
In reply to: 德哥 (#1)
Re: BUG #13441: pg_settings.pending_restart cann't reflect changed setting in configure file.

On Sun, Jun 14, 2015 at 6:26 PM, <digoal@126.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs