PostgreSql:8.4
Select pg_rotate_logfile() does not rotate the log file. If I delete my
log file through the file system and then execute the query it will
create a new log file. But if there is content in the log file and I
run the query it does not seem to do anything. I would have expected it
to clear the log file.
My log files have the days of the week as names. So they get overlaid
each week. I was looking for a way to trigger the clearing of the
current log file.
Thanks,
Lance Campbell
Software Architect/DBA/Project Manager
Web Services at Public Affairs
217-333-0382