Log each DB to a diffrent file

Поиск
Список
Период
Сортировка
От Michael Ben-Nes
Тема Log each DB to a diffrent file
Дата
Msg-id 42335369.5060506@canaan.co.il
обсуждение исходный текст
Список 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
--------------------------


В списке pgsql-general по дате отправления:

Предыдущее
От: "Andrus Moor"
Дата:
Сообщение: Using sequence name depending on other column
Следующее
От: Vitaly Belman
Дата:
Сообщение: Moving an object (function/table, etc) from schema to schema