Re: serverlog rotation/functions

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: serverlog rotation/functions
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE34BE54@algol.sollentuna.se
обсуждение исходный текст
Ответ на serverlog rotation/functions  (Andreas Pflug <pgadmin@pse-consulting.de>)
Ответы Re: serverlog rotation/functions  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-patches
> > Probably the big thing this program was trying to solve was for the
> > server to know the output file name, even with log file
> rotation, and
> > I don't see a pipe and 'rotatelogs' process really addressing this.
>
> It could be done.  Given the infrastructure we have now, it's
> possible to imagine the log capture process being a child of
> the postmaster that can respond to GUC SIGHUPs (or forget
> that and just freeze the file name pattern at PGC_POSTMASTER
> time, which isn't really that big a drawback).
> You'd need the postmaster to create the pipe and then
> re-point its own stdout and stderr at it, but that's doable
> on Unixen at least (I'm less sure about Windows).

Given the issues we've had with stdout/stderr on mingw, I'm not
convinced it will work there. But I'm not convinced it won't work either
:-) What would be the portable way to do it on *nix - I could always run
some tests on w32. Just "stderr = mynewpipe;" is a bit too simplistic,
right?

The other option would be to go with a syslog-style implementation,
which you write explicitly to over a socket. But that won't address your
concern below (from other mail).

> The fundamentally unfixable problem with his method is that
> it can only capture elog output, not stderr output from
> libraries that we don't control (the dynamic linker being the
> biggest case, but there are others).

How common are these issues really? Just getting to the normal backend
output would probably be a big win in most sitations, wouldn't it? In
the case these libraries put out information, we get an elog() call *as
well*, don't we? Then you could easily redirect stderr somewhere on the
server, while still processing "ordinary elog output" through the log
manager.


//Magnus


В списке pgsql-patches по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: PITR Archive Recovery plus WIP PITR
Следующее
От: Oliver Elphick
Дата:
Сообщение: Re: [HACKERS] Is "trust" really a good default?