|
Home > Archive > PostgreSQL Administration > January 2006 > pg_autovacuum
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Eran L 2006-01-11, 7:24 am |
| 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Tom Lane 2006-01-11, 9:24 am |
| 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_collecto
r.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Jaime Casanova 2006-01-11, 9:24 am |
| 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 ;)
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
|
|
|
|
|