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-13 Thread Thomas Swan
> 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. stdout/stderr are r

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 broadcast)---

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 t

Re: [HACKERS] rotatelogs integration in pg_ctl

2004-04-13 Thread Thomas Swan
> 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 yo

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 th

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 br

[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. Dre