Re: wishlist: dynamic log volume control

Ed L. wrote:
> 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.

The issue is that you can't set log_connections from psql.  Should we
improve the doc wording?

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073