Log each DB to a diffrent file

From: Michael Ben-Nes <miki(at)canaan(dot)co(dot)il>
To: postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Log each DB to a diffrent file
Date: 2005-03-12 20:39:05
Message-ID: 42335369.5060506@canaan.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Everyone

Im trying to log each DB to a different file.

So I added:
log_line_prefix ='%d :'
To the postgresql.conf

Later using syslog-ng i added a rule to redirect local0 + postgres + 'DB
Name' to specific file.

But sadly that didnt worked as its only work on one line queries.
every select constructed from more then on line didnt obeyed the rule as
the DB name was not at the start of the line.

Any idea how to solve it ?
If not, any other way to do it ?

Thanks

--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2005-03-12 21:05:41 Using sequence name depending on other column
Previous Message Mike Rylander 2005-03-12 20:24:20 Re: partitionning