Tom Lane writes:
> Hiroshi Inoue <Inoue@tpf.co.jp> writes:
> > Do I have to send SIGHUP after changing postgresql.conf ?
>
> In general, yes. I think that for the (still vaporware) archdir option,
> you might not need to: archdir will only be looked at by the checkpoint
> subprocess, and I think that a newly spawned backend will reread
> postgresql.conf anyway. Peter, is that correct?
Nope. The configuration file is only read at postmaster start and after
SIGHUP. If any starting backend would read it automatically, the admin
could never be sure about his edits.
--
Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/