Re: Idea: closing the loop for "pg_ctl reload"

<p dir="ltr">Ah sorry, didn't realize I top posted. I'll test this new one. <p dir="ltr">Payal.<div
class="gmail_quote">OnApr 21, 2015 10:23 PM, "Jan de Visser" <<a
href="mailto:jan@de-visser.net">jan@de-visser.net</a>>wrote:<br type="attribution" /><blockquote class="gmail_quote"
style="margin:00 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On April 21, 2015 09:34:51 PM Jan de Visser
wrote:<br/> > On April 21, 2015 09:01:14 PM Jan de Visser wrote:<br /> > > On April 21, 2015 07:32:05 PM Payal
Singhwrote:<br /> ... snip ...<br /> ><br /> > Urgh. It appears you are right. Will fix.<br /> ><br /> >
jan<br/><br /> Attached a new attempt. This was one from the category 'I have no idea how<br /> that ever worked", but
whatever.For reference, this is how it looks for me<br /> (magic man-behind-the-curtain postgresql.conf editing
omitted):<br/><br /> jan@wolverine:~/Projects/postgresql$ initdb -D data<br /> ... Bla bla bla ...<br />
jan@wolverine:~/Projects/postgresql$pg_ctl -D data -l logfile start<br /> server starting<br />
jan@wolverine:~/Projects/postgresql$tail -5 logfile<br /> LOG:  database system was shut down at 2015-04-21 22:03:33
EDT<br/> LOG:  database system is ready to accept connections<br /> LOG:  autovacuum launcher started<br />
jan@wolverine:~/Projects/postgresql$pg_ctl -D data reload<br /> server signaled<br />
jan@wolverine:~/Projects/postgresql$tail -5 logfile<br /> LOG:  database system was shut down at 2015-04-21 22:03:33
EDT<br/> LOG:  database system is ready to accept connections<br /> LOG:  autovacuum launcher started<br /> LOG: 
receivedSIGHUP, reloading configuration files<br /> jan@wolverine:~/Projects/postgresql$ pg_ctl -D data reload<br />
serversignaled<br /> pg_ctl: Reload of server with PID 14656 FAILED<br /> Consult the server log for details.<br />
jan@wolverine:~/Projects/postgresql$tail -5 logfile<br /> LOG:  autovacuum launcher started<br /> LOG:  received
SIGHUP,reloading configuration files<br /> LOG:  received SIGHUP, reloading configuration files<br /> LOG:  syntax
errorin file "/home/jan/Projects/postgresql/data/postgresql.conf"<br /> line 1, near end of line<br /> LOG: 
configurationfile "/home/jan/Projects/postgresql/data/postgresql.conf"<br /> contains errors; no changes were
applied<br/> jan@wolverine:~/Projects/postgresql$ </blockquote></div>