| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Magnus Hagander <magnus(at)hagander(dot)net> |
| Cc: | arvindwill(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: About logging |
| Date: | 2009-09-25 19:24:26 |
| Message-ID: | dcc563d10909251224t4ba0b989q43cd997dea7ce7d3@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Sep 24, 2009 at 1:09 PM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> On Thu, Sep 24, 2009 at 21:06, <arvindwill(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sam Mason | 2009-09-25 20:34:36 | Re: generic modelling of data models; enforcing constraints dynamically... |
| Previous Message | Scott Marlowe | 2009-09-25 19:18:04 | Re: close inactive client connection |