From: Ivan Dimitrov <dobber@bastun.net>
To: pgsql-admin@postgresql.org
Subject: pg_autovacuum is not working
Date: Fri, 29 Oct 2004 13:04:35 +0300
Message-ID: <200410291304.42472.dobber@bastun.net> (raw)
Hi list
This is my first post here, and I've searched google but couldn't find the
solution.
I'm trying to run pg_autovacuum on all my databases. All my Debian sarge
machines use version 7.4.5-3
postgresql install
postgresql-client install
postgresql-contrib install
postgresql-dev install
postgresql-doc install
postgres.conf options are
stats_start_collector = true
stats_row_level = true
postmaster.conf options are
AUTOVACUUM=yes
AVAC_LOG=/var/log/postgresql/autovacuum_log
pg_hba.conf options are
local all postgres ident sameuser
local all all ident sameuser
restart postgresql gives this message in the logs:
autovacuum.log
[2004-10-29 12:41:20 PM] Error: GUC variable stats_row_level must be enabled.
[2004-10-29 12:41:20 PM] Please fix the problems and try again.
postgres.log
2004-10-29 12:48:58 [29677] LOG: unexpected EOF on client connection
What could be the reason for this. I have a test machine with the exact same
options and databases as the production servers and it works find there. But
on ~15 production servers I can't get rid of this message.
I can provide strace of pg_autovacuum, but I didn't find many usefull
information in it.
Please advice
--
Hi! I'm your friendly neighbourhood signature virus.
Copy me to your signature file and help me spread!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: dobber@bastun.net
Subject: Re: pg_autovacuum is not working
In-Reply-To: <200410291304.42472.dobber@bastun.net>
References: <200410291304.42472.dobber@bastun.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox