Thread: Re: Postgres Log Rolling

Re: Postgres Log Rolling

From
heatherm@famoice.com
Date:
Naomi,

We're using Red Hat Linux logrotate to do this
A file we called pgsql is put in the /etc/logrotate.d directory, it's
contents are as follows
/var/log/pgsql {
    rotate 5
    copytruncate
    daily
    size=1k
}
This rotates the log files each morning when the daily cron jobs are
run. We found copytruncate to be the key, since without it the logs
weren't rotated.
Hope this helps
Heather Murray.

> -----Original Message-----
> From: nwalker [mailto:nwalker@eldocomp.com]
> Sent: Thursday, 21 February 2002 05:47
> To: pgsql-admin
> Cc: nwalker
> Subject: FW: [ADMIN] Postgres Log Rolling
>
>
>
> This should be an easy one, but......
>
> We need to start rolling our postgres error logs.  I wondered
> whether or
> not I could pull the rug out from under postgres by just renaming the
> pgsql.log to 'date'.log and then recreating (touch pgsql.log) the log.
>
> I then vacuum'd a database (so it would write stuff in the log), and
> noticed that the renamed log ('date'.log) was the one written
> to, not the
> new pgsql.log.
>
> Do I have to bounce the cluster to roll the log?   How should I be
> performing this task?
>
> --
> Naomi Walker
> Chief Information Officer
> Eldorado Computing, Inc.
> 602-604-3100  ext 242
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>