On Sun, May 31, 2020 at 01:43:45PM +0600, Антон Пацев wrote: > Hello! > When parameter cannot be changed without restarting the server postgresql > write: > "LOG: configuration file "/var/lib/postgresql/data/postgresql.auto.conf" > contains errors; unaffected changes were applied" > May be not write this string to LOG? > > This string confuses people. If all log send to ELK, then > administrator think that postgresql have error. But postgresql do not have > error.
I think you're suggesting that the message should be sent to the client, but not to the log. But I think it *should* go to the log; otherwise, a bad change might cause the server to later refuse to start. Any admins or monitoring system watching the log should have the ability to see that a change isn't effective. That's also why (in my mind) we have pg_settings.pending_restart. -- Justin
