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 |