Thread: Log each DB to a diffrent file

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
--------------------------