Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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. > > Frankly, I do not believe that database users should have anything to do > with the log rotation process. Do we have a TODO for allowing users to > force switching to a new WAL file segment?
I thought rotatelogs supported it so we should in cases where someone wanted to make a new log file to delete an unusually large one, like a 1 gig log file caused by some runaway process. However, I see rotatelogs doesn't have that capability so I guess we don't need it either. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])