Re: pg_autovacuum log size in postgres v8.0 - Mailing list pgsql-admin

From Matthew T. O'Connor
Subject Re: pg_autovacuum log size in postgres v8.0
Date
Msg-id 439ECB16.3090703@tocr.com
Whole thread Raw
In response to Re: pg_autovacuum log size in postgres v8.0  (Jeff Frost <jeff@frostconsultingllc.com>)
List pgsql-admin
As Alvaro already mentioned this is fixed in 8.1 because it was
integrated into the backend and benifits from the logging features that
backend already has developed.

As for the 7.4.x & 8.0.x versions of contrib autovacuum, I don't think
there are any plans for improving it.  Also, added it to your logrotate
would probably be a bad idea as it has no code to reopen it's log files
on SIGHUP nor is killing and restarting the autovacuum process a good
idea as contrib/autovacuum loses track of activity when it restarts.

Matt



Jeff Frost wrote:
> Most people running Linux would add it to their logrotate.conf or
> other log management methods.
>
>
> On Mon, 12 Dec 2005, Ameet Kini wrote:
>
>>
>> Any plans of incorporating it into a future release? How do people
>> currently deal with this problem? I wonder if this is fixed in the
>> pg_autovacuum distributed with v8.1
>>
>


pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_autovacuum log size in postgres v8.0
Next
From: Chris Hoover
Date:
Subject: PG 8.1.1 rhel-as-4 rpms missing