Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Thomas Swan
quote who=Andrew Hammond Tom Lane wrote: Andrew Hammond [EMAIL PROTECTED] writes: I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Why bother? You just pipe pg_ctl's output to rotatelogs and you're done. It's not difficult to do, once you know

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Bruno Wolff III
On Tue, Apr 13, 2004 at 09:33:42 -0500, Thomas Swan [EMAIL PROTECTED] wrote: Is there a reason the postmasters cannot just close/reopen-recreate the log file when a SIGHUP or other signal is issued like apache? This would allow for almost any scheme for log rotation to be handled by the

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Peter Eisentraut
Thomas Swan wrote: Is there a reason the postmasters cannot just close/reopen-recreate the log file when a SIGHUP or other signal is issued like apache? Yes, because there is no log file. The postmaster writes to stdout or stderr. ---(end of

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Thomas Swan
quote who=Peter Eisentraut Thomas Swan wrote: Is there a reason the postmasters cannot just close/reopen-recreate the log file when a SIGHUP or other signal is issued like apache? Yes, because there is no log file. The postmaster writes to stdout or stderr. Ok, my misunderstanding.

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Peter Eisentraut
Thomas Swan wrote: Would there be any interest in modifying postmaster to support native file logging in addition to stderr and stdout output? Are there any terrible drawbacks that you could foresee? We have about 8 years of mailing list archives describing them.

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-08 Thread Andrew Hammond
Tom Lane wrote: Andrew Hammond [EMAIL PROTECTED] writes: I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Why bother? You just pipe pg_ctl's output to rotatelogs and you're done. It's not difficult to do, once you know how and once you know that

[HACKERS] rotatelogs integration in pg_ctl

2004-03-24 Thread Andrew Hammond
I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Is there any interested in the community for such a thing? I have not yet added the appropriate stuff to autoconf to completely integrate this. I would appreciate any suggestions for improvement.

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-03-24 Thread Tom Lane
Andrew Hammond [EMAIL PROTECTED] writes: I've attached a patch for pg_ctl which integrates the Apache project's rotatelogs for logging. Why bother? You just pipe pg_ctl's output to rotatelogs and you're done. regards, tom lane ---(end of