postgresql.auto.conf and reload

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема postgresql.auto.conf and reload
Дата
Msg-id 20140625124129.GE29108@msg.df7cb.de
обсуждение исходный текст
Ответы Re: postgresql.auto.conf and reload
Список 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 по дате отправления:

Предыдущее
От: Dean Rasheed
Дата:
Сообщение: Re: RLS Design
Следующее
От: Christoph Berg
Дата:
Сообщение: ALTER SYSTEM RESET?