Re: Log rotation - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Log rotation
Date
Msg-id 008e01c1daf0$cd683790$5ce8fea9@GMENDOLA2
Whole thread Raw
In response to Log rotation  ("Gaetano Mendola" <mendola@bigfoot.com>)
List pgsql-admin
"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");









pgsql-admin by date:

Previous
From: "Marin Dimitrov"
Date:
Subject: Re: indexes separate from data
Next
From: "Nicholay P. Chuprynin"
Date:
Subject: INDEX issues