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 по дате отправления: