| From: | Andy Colson <andy(at)squeakycode(dot)net> |
|---|---|
| To: | Alexey Klyukin <alexk(at)commandprompt(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | REVIEW proposal: a validator for configuration files |
| Date: | 2011-09-07 03:40:08 |
| Message-ID: | 4E66E798.7030401@squeakycode.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Alexey, I was taking a quick look at this patch, and have a question for ya.
I have a default config from initdb, there is a new setting at the end but its commented out.
root(at)storm: /db/pg92
# /etc/rc.d/postgresql start
Starting PostgreSQL:
root(at)storm: /db/pg92
# more serverlog
LOG: database system was shut down at 2011-09-06 22:30:17 CDT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
root(at)storm: /db/pg92
# /etc/rc.d/postgresql reload
Reload PostgreSQL: No directory, logging in with HOME=/
root(at)storm: /db/pg92
# more serverlog
LOG: database system was shut down at 2011-09-06 22:30:17 CDT
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
LOG: received SIGHUP, reloading configuration files
WARNING: errors detected while parsing configuration files
WARNING: errors detected while parsing configuration files
WARNING: errors detected while parsing configuration files
WARNING: errors detected while parsing configuration files
WARNING: errors detected while parsing configuration files
I didn't edit the config, it was fine at startup, so why does reload upset it so? Also, what line is the warning for?
If I edit postgresql.conf and just add bob at the last line, then reload:
LOG: received SIGHUP, reloading configuration files
LOG: syntax error in file "/db/pg92/postgresql.conf" line 570, near end of line
FATAL: errors detected while parsing configuration files
Where did the other warnings go? Its right though, line 570 is bad. It also seems to have killed the server. I have not gotten through the history of messages regarding this patch, but is it supposed to kill the server if there is a syntax error in the config file?
-Andy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavan Deolasee | 2011-09-07 07:05:07 | Re: REVIEW Single pass vacuum - take 2 |
| Previous Message | Fujii Masao | 2011-09-07 03:10:09 | Re: regular logging of checkpoint progress |