Received: from nts-03.mm.eutelsat.org (nts-03.mm.eutelsat.org
 [194.214.173.15])
	by postgresql.org (Postfix) with ESMTP id 69074475892
	for <pgsql-admin@postgresql.org>; Thu, 28 Mar 2002 13:54:16 -0500 (EST)
Received: from dell-01.mm.eutelsat.org (IDENT:root@dell-01.mm.eutelsat.org
	[194.214.173.17])
	by nts-03.mm.eutelsat.org (8.9.3/8.8.7) with ESMTP id TAA15229
	for <pgsql-admin@postgresql.org>; Thu, 28 Mar 2002 19:52:21 +0100
Received: from GMENDOLA2 (gmendola2.mm.eutelsat.org [194.214.173.26])
	by dell-01.mm.eutelsat.org (8.11.2/8.8.7) with SMTP id g2SIsAF15731
	for <pgsql-admin@postgresql.org>; Thu, 28 Mar 2002 19:54:10 +0100
Message-ID: <009d01c1d689$f5878ed0$5ce8fea9@GMENDOLA2>
From: "Gaetano Mendola" <mendola@bigfoot.com>
To: <pgsql-admin@postgresql.org>
Subject: Log rotation
Date: Thu, 28 Mar 2002 19:54:15 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200203/334
X-Sequence-Number: 3868

Hi to all,

I configured the log rotation of postgresql  started in this way:

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl  -D $PGDATA -p
/usr/bin/postmaster start  > /var/log/postgresql.log 2>&1" < /dev/null

with the log rotate file:

/var/log/postgresql.log {
    compress
    rotate 5
    size=10000k
    create 0664 postgres postgres
    daily
    sharedscripts
    copytruncate
}

the problem now is that the postgres server is really
stressed and write continuosly on the log file
and the file is not truncated!!!!!

anyone have any idea??



Ciao
Gaetano

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");