Re: Current log files when rotating? - Mailing list pgsql-general

From Andrus
Subject Re: Current log files when rotating?
Date
Msg-id gfbiei$6q0$1@news.hub.org
Whole thread Raw
In response to Re: Current log files when rotating?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Joao Ferreira gmail
Date:
Subject: merge 2 dumps
Next
From: Richard Huxton
Date:
Subject: Re: Very slow queries w/ NOT IN preparation (seems like a bug, test case)