pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!

view thread (3+ messages)  latest in thread

Message-ID: <200410291304.42472.dobber@bastun.net>
Permalink:  ../200410291304.42472.dobber@bastun.net/
Also on:    postgresql.org/message-id/200410291304.42472.dobber@bastun.net

 · 

reply

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