Re: pg_autovacuum

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Eran L <eranlz(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_autovacuum
Date: 2006-01-11 15:08:51
Message-ID: c2d9e70e0601110708y3347578am867423bdb331aef6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 1/11/06, Eran L <eranlz(at)gmail(dot)com> wrote:
> Hi,
>
> I must be missing some obvious and trivial thing, since I simply can
> get pg_autovacuum to work.
>
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
>
> stats_row_level = true
>
> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
>
> [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be enabled.
> [2006-01-11 12:11:07 IST] Please fix the problems and try again.
>
> What more needs to be done ?
>
> TIA,
> Eran
>

i guess you remove the # symbol in front of that line

--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-01-11 15:22:51 Re: postgres 7.2.1 pg_restore large objects
Previous Message Tom Lane 2006-01-11 15:03:44 Re: pg_autovacuum