Обсуждение: pg_autovacuum

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

Eran L <eranlz@gmail.com> writes:
> 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.

Does "SHOW stats_row_level" agree that it's not on?  If so, maybe you
forgot stats_start_collector.

            regards, tom lane

On 1/11/06, Eran L <eranlz@gmail.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 ;)