Re: [HACKERS] log file rotate

2004-08-08 Thread Andreas Pflug
Tom Lane wrote: 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 pu

Re: [HACKERS] log file rotate

2004-08-08 Thread Andreas Pflug
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. - D

Re: [HACKERS] log file rotate

2004-08-07 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > 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. > > Hm? We have a rotate-on-size para

Re: [HACKERS] log file rotate

2004-08-07 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > 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. Hm? We have a rotate-on-size parameter, so that's not going t

Re: [HACKERS] log file rotate

2004-08-07 Thread Bruce Momjian
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

Re: [HACKERS] log file rotate

2004-08-07 Thread Tom Lane
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