Lamar Owen writes:
> Use syslog. Syslog has many advantages:
> 1.) Easily rollable.
> 2.) Redirectable to various files and/or remote machines -- including
> hardcopy, and including multiple files at once (splitting).
> 3.) PostgreSQL 7.1 has excellent syslog support.
> 4.) You don't have to shut anything down to roll the logs.
> 5.) Thanks to item 2, you could have a single syslog machine accept the
> syslog output of multiple PostgreSQL servers, integrating the log into one,
> if you wish.
Disadvantage:
Some messages will get lost.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter