| From: | Thom Brown <thom(at)linux(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Incorrectly reporting config errors |
| Date: | 2014-01-21 18:26:34 |
| Message-ID: | CAA-aLv7mfPiqcn6ntx3qnxZ+5xiFXsgqEWF64RHHnZEy32NFYQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi all,
I'm getting a report of a config error when changing a config value
that requires a restart:
In postgresql.conf
max_connections = 92
(pg_ctl restart)
postgres=# show max_connections ;
max_connections
-----------------
92
(1 row)
(Edit postgresql.conf so that max_connections = 93)
(pg_ctl reload)
Now the log file contains:
2014-01-21 18:14:53 GMT [28718]: [4-1] user=,db=,client= LOG:
received SIGHUP, reloading configuration files
2014-01-21 18:14:53 GMT [28718]: [5-1] user=,db=,client= LOG:
parameter "max_connections" cannot be changed without restarting the
server
2014-01-21 18:14:53 GMT [28718]: [6-1] user=,db=,client= LOG:
configuration file "/home/thom/Development/data/postgresql.conf"
contains errors; unaffected changes were applied
It doesn't contain errors. I changed the 92 to 93. If I restart, it
doesn't complain, and there's nothing in the log about the config
anymore.
This seems to be the case for any parameter with a postmaster context.
I can understand why it logs the message about it not changing without
a restart, but the other one seems like a bug.
I've tested this on 9.3 and 9.4devel.
Thom
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2014-01-21 18:31:08 | Re: Bug? could not remove shared memory segment |
| Previous Message | Marko Tiikkaja | 2014-01-21 18:13:13 | Re: array_length(anyarray) |