Re: log file rotate

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
>>Tom, you didn't like Andreas' idea of allowing the user to rotate the
>>log files on demand.
> 
> 
> 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.

- Debugging some stuff, a distinct period of work, I'd like to start 
with a fresh serverlog.
- When doing a backup, I'd like to continue with a fresh serverlog so I 
can see what was happening since that point in time.

MSSQL calls this sp_cycle_errorlog.

I can't see even a marginal decrease of reliability, since the logger 
already accepts SIGHUP, and will reevaluate postgresql.conf to set the 
rotation_requested flag accordingly; I'm just asking for setting the 
flag directly.


Regards,
Andreas