Re: expanding on syslog help

Robert Treat wrote:
> On Tue, 2003-09-30 at 01:44, Christopher Kings-Lynne wrote:
> > * Mention that you might want to turn log_pid and log_timestamp off
> > since syslog logs them anyway
> >
>
> i think that debug_pretty_print is somewhat pointless too, as syslog
> tends to wrap lines automagically... could be others.
>
> > * Mention something about system log rotator? Or is that too
> > platform-specific?
> >
>
> "The simplest production-grade approach to managing log output is to
> send it all to syslog and let syslog deal with file rotation. To do
> this, set the configurations parameter syslog to 2 (to log to syslog
> only) in postgresql.conf. Then you can send a SIGHUP signal to the
> syslog daemon whenever you want to force it to start writing a new log
> file. "
>
> Perhaps add:
> "If you want to automate the log rotation, the logrotate program can be
> configured to work with log files from syslog."
>
> at least, on most linux distros (and I'm just guessing others) this is
> how they come configured.

Added. Thanks.

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