Re: Log rotation

Patrick Welche wrote:
> On Sat, Mar 13, 2004 at 10:36:23AM -0500, Fernando Nasser wrote:
> 
>>Lamar Owen wrote:
>>
>>>Ok, riddle me this:
>>>
>>>If I have PostgreSQL set to log to syslog facility LOCAL0, and a 
>>>local0.none on /var/log/messages and local0.* to /var/log/pgsql (assuming 
>>>only one postmaster, unfortunately) then you get a flat file.
>>
>>The problem is that sysloging has more overhead than a plain append to a 
>>file.  There are some very strict response time AppServer applications 
>>where we want to keep this things out of the picture.
> 
> 
> I thought it was an advantage to say "log to that box running syslog over
> there and leave my disk alone" - what do you have in mind with "AppServer
> applications" ?
> 

And add more packets to the network, buffering etc.?  I don't think so.

There are some applicatons which run in servers with very strict 
response times and any syscall, network packet that can be saved counts.

> 
>>It may be desirable to logrotate them at different times as well, so 
>>they would have to be in different files.
> 
> 
> syslogd with newsyslog, just like any other log file? I must be missing
> something.. I don't see why postgresql is different..
> 

The number of generated messgaes.

Maybe that is an area that can be worked on, i.e. reducing log 
verbosity.  Is 7.4.x much better than 7.3.x in that respect?



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