On Fri, Dec 02, 2005 at 23:30:21 +0100,
Dick Snippe <[EMAIL PROTECTED]> wrote:
>
> Using a log rotation program is possible (apache rotatelogs comes to mind),
> but that would require starting postgresql with something like
> postmaster | rotatelogs
> and just hope that rotetelogs doesn't die in the weeks or months that
> postmaster runs. Also postmaster can't be started as a daemon in this case.
You can use multilog in DJB's daemontools package to do this.
It writes the logfiles publicly readable, so you control access to them via
the directory they are contained in.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
