Log files, how to rotate properly - Mailing list pgsql-general

From Dave Cramer
Subject Log files, how to rotate properly
Date
Msg-id 0ad101c0f42a$374fe300$0302a8c0@INSPIRON
Whole thread Raw
In response to Re: Re: Does PostgreSQL support EXISTS?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Log files, how to rotate properly
List pgsql-general
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


pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: index on a box
Next
From: "Fabrizio Mazzoni"
Date:
Subject: sum of row values..