Re: [PORTS] Logging (was Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [PORTS] Logging (was Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.)
Date
Msg-id Pine.LNX.4.21.0005222353580.392-100000@localhost.localdomain
Whole thread Raw
Responses Re: [PORTS] Logging (was Re: [GENERAL] PostgreSQL 7.0-2 RPMset released.)
List pgsql-hackers
Palle Girgensohn writes:

> > > The real problem with redirecting the postmaster output is the issue
> > > of log rolling,

> I really enjoy using apache's rotatelogs program. stderr is
> redirected through a pipe to a very small and robust C program,
> rotatelogs, that takes as arguments number of seconds between
> log rotates and the log filename. Logs are rotated every
> argv[2] seconds. The rotatelogs program takes care of closing
> and reopening, and nothing has to done from the application,
> just start postmaster with '2>&1 | rotatelogs ...' at the end,
> and log to stderr.

Now there's a good idea. Why don't we abduct that program and teach pg_ctl
about it. (After all, we abducted that one as well. :)


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Last call for comments: fmgr rewrite [LONG]
Next
From: Hannu Krosing
Date:
Subject: Re: OO Patch