Re: Log files, how to rotate properly

Answer: Use syslog.

-alex
On Wed, 13 Jun 2001, Dave Cramer wrote:

> I just ran into an interesting problem. My /var partition was full, and the
> culprit turned out to be the postgres log file, which was only evident
> through lsof. It was actually a deleted file which was being kept open by
> the running process.
>
> The interesting thing is that if I redirect the output of postmaster, then
> every connection has this file open.
>
> My environment is Apache/jserv/postgres. So in order to rotate the postgres
> log, I would have to
>
> 1) Shut apache down,
> 2) Shut jserv down
> 3) Shut postgres down
> rotate the logs, then bring them all back up again
>
> Is there a way to tell postgres to release the log file, or am I completely
> off base here?
>
> Dave
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>