Postgres Pro
Downloads
Home   >   mailing lists

Log each DB to a diffrent file - Mailing list pgsql-general

From Michael Ben-Nes
Subject Log each DB to a diffrent file
Date
Msg-id 42335369.5060506@canaan.co.il
Whole thread Raw
List pgsql-general
Tree view 
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
--------------------------

pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: Using sequence name depending on other column
Next
From: Vitaly Belman
Date:
Subject: Moving an object (function/table, etc) from schema to schema