Re: Current log files when rotating?

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: Current log files when rotating?
Дата
Msg-id gfbiei$6q0$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Current log files when rotating?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
>> It seems that there is enough need for this feature, that it has been
>> implemented multiple times -- but most of them will fail in corner
>> cases.  Seems an obvious candidate for an in-core function ...
>
> ... which will still fail in corner cases.  Not to mention the race
> condition when the logger has just/is about to switch.

Best way is to integrate log retrieval into language:

select *
from pg_log_current ;
order by logtime desc
limit 1000

or

select *
from pg_log_current(1000)

Andrus.

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

Предыдущее
От: Joao Ferreira gmail
Дата:
Сообщение: merge 2 dumps
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)