""Johnson, Shaunn"" <SJohnson6@bcbsm.com> wrote in message
news:73309C2FDD95D11192E60008C7B1D5BB04C73F9B@snt452.corp.bcbsm.com...
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C26310.AA038860
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Howdy:
>
> Running PostgreSQL 7.2.1 on RedHat Linux 7.2 kernel 2.4.7.
>
> Can someone send an example of how they have the
> logrotate / rotatelog script working with PostgreSQL?
> I'm looking at a few things and I can't seem to
> get it to work.
Hi, I seen a lot of reply, but I don't understand why all
of us should crambling on the mirror for resolve a tipical
problem already well solved on Linux box?
Anyway how alread I suggested times ago the following
way ( why don't put this in the documentation or in
the FAQ ? ):
Insert in your postgresql.conf the following lines:
# File postgresql.conf
syslog = 2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'
Create a file postgres under your /etc/logrotate/postgres
( the path depend on your installation )
#File postgres
/var/log/postgresql.log {
compress
rotate 2
size=10000k
create 0664 postgres postgres
daily
postrotate
/usr/bin/killall -HUP syslogd
endscript
}
Take a look at the option that you need.
in the syslog.conf add the following lines:
# Save postgresql logs
LOCAL0.* /var/log/postgresql.log
be sure that the file /var/log/postgresql.log is owned by
postgres.
Send a SIGHUP to postmaster and syslog after that setting.
For test if the logrotate is working well force a rotation:
$> logrotate -f /etc/logrotate/postgres
Ciao
Gaetano
