From: | Keith <keith(at)keithf4(dot)com> |
---|---|
To: | Ertan Küçükoğlu <ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Separate log for a specfic database |
Date: | 2018-02-28 18:41:29 |
Message-ID: | CAHw75vt31_+Ghc6oMvDqbjc=89FvgBxnUbznArF8xAfM3cNYOw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, Feb 28, 2018 at 12:35 PM, Ertan Küçükoğlu <
ertan(dot)kucukoglu(at)1nar(dot)com(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Rui DeSousa | 2018-02-28 18:49:33 | Re: Reliable WAL file shipping over unreliable network |
Previous Message | David G. Johnston | 2018-02-28 18:37:41 | Re: Postgresql | Vacuum information |