From: Gaetano Mendola <mendola@bigfoot.com>
To: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-sql@postgresql.org
Subject: Re: core file found...
Date: Sun, 12 May 2002 12:24:57 +0200
Message-ID: <002301c1f99f$440c0800$d5a9fea9@GMENDOLA2> (raw)
References: <200205101048.g4AAmAK03594@saturn.janwieck.net>
<200205111019.32793.mallah@trade-india.com>
<12721.1021129283@sss.pgh.pa.us>
<200205121110.28249.mallah@trade-india.com>
"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");
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mendola@bigfoot.com, mallah@trade-india.com, tgl@sss.pgh.pa.us
Subject: Re: core file found...
In-Reply-To: <002301c1f99f$440c0800$d5a9fea9@GMENDOLA2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox