Give me a use case that requires that, and is sufficiently interesting to justify even a marginal decrease in the reliability of the log process.
Frankly, I do not believe that database users should have anything to do with the log rotation process.
The (super)user will sometimes purge old files, so he *does* have to do something with the rotation process' output. It's up to him what he regards as old, maybe everything before 'now'.
YAUC (yet another use case): rotating every day at 3 am.
Regards, Andreas
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster