Received: from nts-03.mm.eutelsat.org (nts-03.mm.eutelsat.org
 [194.214.173.15])
	by postgresql.org (Postfix) with ESMTP id 3D5E9475452
	for <pgsql-admin@postgresql.org>; Wed,  3 Apr 2002 04:20:41 -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 LAA15683;
	Wed, 3 Apr 2002 11:18:40 +0200
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 g339KVF08142;
	Wed, 3 Apr 2002 11:20:31 +0200
Message-ID: <008e01c1daf0$cd683790$5ce8fea9@GMENDOLA2>
From: "Gaetano Mendola" <mendola@bigfoot.com>
To: "Andre Schubert" <andre.schubert@km3.de>
Cc: <pgsql-admin@postgresql.org>
References: <009d01c1d689$f5878ed0$5ce8fea9@GMENDOLA2>
	<3CA93986.C721718E@km3.de>
Subject: Re: Log rotation
Date: Wed, 3 Apr 2002 11:20:31 +0200
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: 200204/25
X-Sequence-Number: 3914

"Andre Schubert" <andre.schubert@km3.de> wrote:
> You can use multilog on linux.


Hi, I don't know what's multilog but I resolved my
problem in this way (general suggestions for all):

#File postgresql.conf

syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'


#File /etc/logrotate.d/postgres

/var/log/postgresql.log {
    compress
    rotate 5
    size=10000k
    errors mendola@bigfoot.com
    create 0664 postgres postgres
    daily
    postrotate
           /usr/bin/killall -HUP syslogd
    endscript
}


#In File syslog.conf
LOCAL0.*
/var/log/postgresql.log


Ciao
Gaetano

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