Re: Log rotation

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: "Andre Schubert" <andre(dot)schubert(at)km3(dot)de>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Log rotation
Date: 2002-04-03 09:20:31
Message-ID: 008e01c1daf0$cd683790$5ce8fea9@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Andre Schubert" <andre(dot)schubert(at)km3(dot)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(at)bigfoot(dot)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");

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Nicholay P. Chuprynin 2002-04-03 12:25:25 INDEX issues
Previous Message Marin Dimitrov 2002-04-03 07:50:34 Re: indexes separate from data