Re: About logging - Mailing list pgsql-general

From Scott Marlowe
Subject Re: About logging
Date
Msg-id dcc563d10909251224t4ba0b989q43cd997dea7ce7d3@mail.gmail.com
Whole thread Raw
In response to Re: About logging  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
On Thu, Sep 24, 2009 at 1:09 PM, Magnus Hagander <magnus@hagander.net> wrote:
> On Thu, Sep 24, 2009 at 21:06,  <arvindwill@gmail.com> wrote:
>> Is it possible to log two different information to two different file.
>> Bascially i need to log all the mod statement in one log csv file and all
>> the queries running more then 2mins in another csv log file. As i enabled
>> both it will be doing both in single file rt . Is there any way to split
>> both???
>
> This is not currently possible inside PostgreSQL, you will need to do
> external post-processing of the logfile to get that.

I bet it wouldn't be hard to mangle apache's log rotator to do
something like put all entries with DB1 at the start to one file and
all the others in another file.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: close inactive client connection
Next
From: Sam Mason
Date:
Subject: Re: generic modelling of data models; enforcing constraints dynamically...