Re: Alter system and reload causes bogus complaints about setting changes

On Thu, Jul 3, 2014 at 2:46 PM, Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
wrote:
>
> Hi all, playing with 9.4 beta:
>
> Consider:
>
> $ cat config.sql
> ALTER SYSTEM SET max_connections = 200;
> ALTER SYSTEM SET shared_buffers = "10GB";
>
> $ psql < config.sql
>
> $ service postgresql restart
>
> $ psql
> ALTER SYSTEM SET checkpoint_segments = 384;
> \q
>
> $ service postgresql reload
>
> $ tail /var/log/postgresql/postgresql-9.4-main.log
> 2014-07-03 08:09:40 AST LOG:  received SIGHUP, reloading configuration
files
> 2014-07-03 08:09:40 AST LOG:  parameter "max_connections" cannot be
changed without restarting the server
> 2014-07-03 08:09:40 AST LOG:  parameter "shared_buffers" cannot be
changed without restarting the server
> 2014-07-03 08:09:40 AST LOG:  parameter "checkpoint_segments" changed to
"1920"
> 2014-07-03 08:09:40 AST LOG:  configuration file
"/etc/postgresql/9.4/main/postgresql.conf" contains errors; unaffected
changes were applied
>
>
> Hmmm - I didn't actually change the settings it is complaining
about...and it is referring to the wrong file too. While this is hardly
serious, it is likely to be immensely confusing for folk who have not been
actively following the new changes for 9.4 (ahem...that could be a lot of
people). It would be good to fix this before we end beta.

This issue occurs mainly due to duplicate settings in postgresql.conf
and postgresql.auto.conf (file where ALTER SYSTEM writes).  I have
explained it in more detail in the below thread:

http://www.postgresql.org/message-id/CAA4eK1+mUTjc=GXJK3bYtSwV2BmBni=PHEvBqLQkhdUV9cWd1A@mail.gmail.com


With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com