Re: Separate log for a specfic database

Поиск
Список
Период
Сортировка
От Keith
Тема Re: Separate log for a specfic database
Дата
Msg-id CAHw75vt31_+Ghc6oMvDqbjc=89FvgBxnUbznArF8xAfM3cNYOw@mail.gmail.com
обсуждение исходный текст
Ответ на Separate log for a specfic database  (Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr>)
Ответы Re: Separate log for a specfic database
Список pgsql-admin


On Wed, Feb 28, 2018 at 12:35 PM, Ertan Küçükoğlu <ertan.kucukoglu@1nar.com.tr> wrote:
Hello,

I am using PostgreSQL 9.6.6 on Debian 9 Stretch system. Installed using
apt-get.
I wonder if I can have two log files. One for complete database server and
another for one specific database in the server.
I have already read below link, but cannot understand if that is possible,
or how.
https://www.postgresql.org/docs/9.6/static/runtime-config-logging.html

I appreciate any help.

Regards,
Ertan Küçükoğlu





Not sure what you're reasoning may be, but if it's just to be able to do log analysis, there are tools that can do that for you as long as you have the database name in the log_line_prefix. Take a look at pgbadger

http://dalibo.github.io/pgbadger/

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Postgresql | Vacuum information
Следующее
От: Rui DeSousa
Дата:
Сообщение: Re: Reliable WAL file shipping over unreliable network