Lists: | pgsql-performance |
---|
From: | shailesh singh <shaileshjuly(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | issue related to logging facility of postgres |
Date: | 2011-07-27 09:11:09 |
Message-ID: | CAAzPmNwxPqYNKkZeaX6s0vYgvq8joGs7KpwcT=cwwf-e-K8+TA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
Hi,
I want to configure Logging of postgres in such a way that messages of
different severity should be logged in different log file. eg: all ERROR
message should be written in error-msg.log file while all NOTICE mesage
should be written in notice-msg.log file.
In order to do that what changes should i need to do in configuration file ?
Could you pl give a solution.
--
With Regards,
Shailesh Singh
From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
---|---|
To: | shailesh singh <shaileshjuly(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: issue related to logging facility of postgres |
Date: | 2011-09-01 00:12:53 |
Message-ID: | CA+TgmoZ7tDodaYZpZoaujwr81vfzrQnFYimVZgvGhhoaMn2QDQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
On Wed, Jul 27, 2011 at 5:11 AM, shailesh singh <shaileshjuly(at)gmail(dot)com> wrote:
> I want to configure Logging of postgres in such a way that messages of
> different severity should be logged in different log file. eg: all ERROR
> message should be written in error-msg.log file while all NOTICE mesage
> should be written in notice-msg.log file.
>
> In order to do that what changes should i need to do in configuration file ?
> Could you pl give a solution.
There's no such facility built-in. You might want to do something
like "log everything in CSV format, and then run a Perl script over
it afterwards to split it up".
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From: | Justin Pitts <justinpitts(at)gmail(dot)com> |
---|---|
To: | shailesh singh <shaileshjuly(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: issue related to logging facility of postgres |
Date: | 2011-09-01 11:51:27 |
Message-ID: | CAMYZu8V04KBeo36==40y1jSr=oX7ngdVMticrcF45NntS2n-wA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-performance |
Syslog does that, I believe. Have a look at the man page for syslog.conf.
On Wed, Jul 27, 2011 at 5:11 AM, shailesh singh <shaileshjuly(at)gmail(dot)com> wrote:
> Hi,
> I want to configure Logging of postgres in such a way that messages of
> different severity should be logged in different log file. eg: all ERROR
> message should be written in error-msg.log file while all NOTICE mesage
> should be written in notice-msg.log file.
>
> In order to do that what changes should i need to do in configuration file ?
> Could you pl give a solution.
>
> --
> With Regards,
> Shailesh Singh
>
>
>