On Wednesday February 18 2004 9:33, Tom Lane wrote:
> "Ed L." <pgsql@bluepolka.net> writes:
> > "It'd be nice" if we
> > could adjust the volume of logging dynamically (i.e., turn-off of
> > statement logging, etc) without have to restart the server...
>
> Why do you think you need to restart the server? Adjust postgresql.conf
> and SIGHUP the postmaster.
Well, on closer look, there it is in plain sight in the runtime config
documentation I've looked through a hundred times for other purposes. Just
one of many features I haven't discovered, I guess.
The 7.3.4 doc (doc/html/runtime-config.html) does say the log_connections
option can only be set at server start or in the postgresql.conf
configuration file. That seems a little ambiguous on the SIGHUP'ability of
that option. My 7.3.4 install here shows all the log_* options are
dynamically reloadable.