Log files, how to rotate properly
Dave Cramer <dave@micro-automation.net>
From: "Dave Cramer" <Dave@micro-automation.net>
To: <pgsql-general@postgresql.org>
Date: 2001-06-13T17:20:02Z
Lists: 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