Re: rotatelog / logrotate with PostgreSQL

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: rotatelog / logrotate with PostgreSQL
Date: 2002-09-26 08:07:15
Message-ID: amuf7g$30a8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Martijn van Oosterhout" <kleptog(at)svana(dot)org> wrote in message
news:20020926004757(dot)GC5706(at)svana(dot)org(dot)(dot)(dot)
> On Wed, Sep 25, 2002 at 08:58:22AM -0600, scott.marlowe wrote:
> > Well, I've found the syslog facility to be noticeable slower than
> > rotatelogs with pgsql doing its own logging. So that's why I do it the
> > rotatelogs way. Choice is good.
>
> One thing to be careful of is to put a hyphen before the filename in the
> syslog config. This will stop syslog doing a sync() after *every* message,
> which quite noticably kills performance. Also make sure it's only logging
to
> the logs you want and not to multiple files.

That's right, but I think that all here knew this, or not ?

Ciao
Gaetano

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2002-09-26 08:35:44 Performance while loading data and indexing
Previous Message Bruce Momjian 2002-09-26 05:16:12 Re: postmaster -d option (was Re: [GENERAL] Relation 0 does not exist)