Re: rotatelog / logrotate with PostgreSQL

Martijn van Oosterhout <kleptog@svana.org>

From: Martijn van Oosterhout <kleptog@svana.org>
To: "scott.marlowe" <scott.marlowe@ihs.com>
Cc: Gaetano Mendola <mendola@bigfoot.com>, pgsql-general@postgresql.org
Date: 2002-09-26T00:47:57Z
Lists: pgsql-general
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.

Hope this helps,
-- 
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.