Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id 033764759A9
	for <pgsql-sql@postgresql.org>; Sun, 12 May 2002 06:33:45 -0400 (EDT)
Received: from pns.mm.eutelsat.org (pns.mm.eutelsat.org [194.214.173.227])
	by postgresql.org (Postfix) with ESMTP id 5E732475988
	for <pgsql-sql@postgresql.org>; Sun, 12 May 2002 06:33:42 -0400 (EDT)
Received: from nts-03.mm.eutelsat.org (localhost [127.0.0.1])
	by pns.mm.eutelsat.org (8.11.6/linuxconf) with ESMTP id g4CAOht24233;
	Sun, 12 May 2002 12:24:43 +0200
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 LAA29841;
	Sun, 12 May 2002 11:18:41 +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 g4CAOeL05444;
	Sun, 12 May 2002 12:24:40 +0200
Message-ID: <002301c1f99f$440c0800$d5a9fea9@GMENDOLA2>
From: "Gaetano Mendola" <mendola@bigfoot.com>
To: "Rajesh Kumar Mallah." <mallah@trade-india.com>,
	"Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-sql@postgresql.org>
References: <200205101048.g4AAmAK03594@saturn.janwieck.net>
	<200205111019.32793.mallah@trade-india.com>
	<12721.1021129283@sss.pgh.pa.us>
	<200205121110.28249.mallah@trade-india.com>
Subject: Re: core file found...
Date: Sun, 12 May 2002 12:24:57 +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: 200205/112
X-Sequence-Number: 7748

"Rajesh Kumar Mallah." <mallah@trade-india.com> wrote:
> Yes you are very correct,
>
> postmaster's log had exceed the OS file limit
> which was ~ 2.1 GB  .
>
> i wanted to rotate these log but i do not know
> how to make postmaster recreate a log file while
> it is running.

Well,
the most correct way to do a logrotate is ( Redhat ):

1) Put on your postgresql.conf the following lines:

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

2)  Put on the directory /etc/logrotate.d a file called
'postgres' with the following lines:

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

change the email address of course :-)

3) Put the following line on your /etc/syslog.conf

# Save postgresql logs
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");