Re: Log rotation - Mailing list pgsql-hackers

From Fernando Nasser
Subject Re: Log rotation
Date
Msg-id 40532DBE.4010508@redhat.com
Whole thread Raw
In response to Re: Log rotation  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Rod Taylor wrote:
>>>I can see that in a multipostmaster setting how you might want some
>>>differentiation between postmasters, but ISTM that the tool reading these
>>>logs should be trained in how to separate loglines out. <snip>
>>
>>Different postmasters = different conf files. Just set your syslog_facility 
>>and/or your syslog_ident differently and it should be pretty easy to seperate 
>>the logs.  Actually, now that I have started using syslog fairly regularly, I 
> 
> 
> Not that I'm volunteering, but I think the biggest issue is many users
> simply don't know how to approach the problem. Some docs on using
> syslog, cron, etc. with PostgreSQL to accomplish maintenace jobs would
> probably be enough.
> 

It is very easy to setup logging with the Control Center tool.  Except 
that it does not handle the /etc/syslog.conf bit (you have to add the 
entry to get a specific LOCAL to a specific file by hand.


Maybe someone could make some measurements to desmistify the performance 
impact of syslog.  There is this generalized belief in IS departments 
that should minimize it.  Perhaps is an old fud that is not anylonger true.




-- 
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9


pgsql-hackers by date:

Previous
From: Fernando Nasser
Date:
Subject: Re: Log rotation
Next
From: Patrick Welche
Date:
Subject: Re: Log rotation