Re: Current log files when rotating?

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Current log files when rotating?
Date: 2008-11-11 09:14:52
Message-ID: gfbiei$6q0$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Yasuo Ohgaki 2008-11-11 09:51:49 Re: SQL injection, php and queueing multiple statement
Previous Message Diego Manilla Suárez 2008-11-11 08:56:15 Question about weird construct