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 --------------------------
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match