postgresql.auto.conf and reload - Mailing list pgsql-hackers

From Christoph Berg
Subject postgresql.auto.conf and reload
Date
Msg-id 20140625124129.GE29108@msg.df7cb.de
Whole thread Raw
Responses Re: postgresql.auto.conf and reload  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
I've just run into this:

$ psql -p 5433   (that port is configured in postgresql.conf)
# alter system set port = 5494;

... restart the server

$ psql -p 5494
# select pg_reload_conf();

2014-06-25 14:22:07 CEST [11297-4] LOG:  received SIGHUP, reloading configuration files
2014-06-25 14:22:07 CEST [11297-5] LOG:  parameter "port" cannot be changed without restarting the server
2014-06-25 14:22:07 CEST [11297-6] LOG:  configuration file "/etc/postgresql/9.4/main/postgresql.conf" contains errors;
unaffectedchanges were applied
 

I think reloading shouldn't be nagging me about parameters in
postgresql.conf that are going to be overwritten in
postgresql.auto.conf. Reloading again will issue the warnings again...

It's true that my config has two contradicting settings in there now,
but if that's not an issue at server start, it shouldn't be one for
reloading either.

Christoph
-- 
cb@df7cb.de | http://www.df7cb.de/



pgsql-hackers by date:

Previous
From: Dean Rasheed
Date:
Subject: Re: RLS Design
Next
From: Christoph Berg
Date:
Subject: ALTER SYSTEM RESET?