Обсуждение: issue related to logging facility of postgres
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
On Wed, Jul 27, 2011 at 5:11 AM, shailesh singh <shaileshjuly@gmail.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
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@gmail.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 > > >