Horton

Re: [PORTS] Logging (was Re: PostgreSQL 7.0-2 RPMset released.)

Peter Eisentraut <peter_e@gmx.net>

View thread
From: Peter Eisentraut <peter_e@gmx.net>
To: Palle Girgensohn <girgen@partitur.se>
Cc: pgsql-ports@postgresql.org, "PostgreSQL::General List" <pgsql-general@postgresql.org>, PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2000-05-22T21:58:33Z
Lists: 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