Hi All,<br /><br /> I changed the postgresql.conf file (of an 8.2.4 server), and issued relaod using
pg_reload_config().Following are the messages I see in the log files:<br /><br />May 14 21:38:40 sfphotodb001
postgres[29658]:[19-1] 2008-05-14 21:38:40 PDTLOG: received SIGHUP, reloading configuration files<br /> May 14
21:38:40sfphotodb001 postgres[29658]: [20-1] 2008-05-14 21:38:40 PDTLOG: parameter "shared_buffers" cannot be changed
afterserver start; configuration file change ignored<br />May 14 21:39:03 sfphotodb001 postgres[22928]: [21-1]
2008-05-1421:39:03 PDTLOG: archived transaction log file "0000000100000E23000000C8"<br /><br /><br /> What's
confusingabout this is that the second message says 'configuration file change ignored', so I expect the changed (newly
enabled)archive_command to not take effect. But in fact, it does take effect.<br /><br /> The message probably
shouldbe rephrased to say that this setting (shared_buffers) will not be changed.<br /><br />Best regards,<br
clear="all"/><br />-- <br />gurjeet[.singh]@EnterpriseDB.com<br />singh.gurjeet@{ gmail | hotmail | indiatimes | yahoo
}.com<br/><br />EnterpriseDB <a href="http://www.enterprisedb.com">http://www.enterprisedb.com</a><br /><br />Mail sent
frommy BlackLaptop device