X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 7EA729DC833 for ; Wed, 11 Jan 2006 11:08:49 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95957-05 for ; Wed, 11 Jan 2006 11:08:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.199]) by postgresql.org (Postfix) with ESMTP id 1DAE69DC803 for ; Wed, 11 Jan 2006 11:08:46 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i28so176873wra for ; Wed, 11 Jan 2006 07:08:52 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dCLqvK0TgK3AKrz4PPzAfTsQVQxz7yD4PsE5jE33p5IIeNOQHFf27xOGC1dZ7ZQVgad9LdNWcxSKjiznL/EUgns/HwOkyVIyO5I+L9K+W7pPx+t6g+13UobnyC4TpTBzgOkPcw85+9cSk5NCxNNmiL19ae9G66REK9ShNyXFUbI= Received: by 10.54.141.6 with SMTP id o6mr1036469wrd; Wed, 11 Jan 2006 07:08:51 -0800 (PST) Received: by 10.54.92.14 with HTTP; Wed, 11 Jan 2006 07:08:51 -0800 (PST) Message-ID: Date: Wed, 11 Jan 2006 10:08:51 -0500 From: Jaime Casanova To: Eran L Subject: Re: pg_autovacuum Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.082 required=5 tests=[AWL=0.082] X-Spam-Score: 0.082 X-Spam-Level: X-Archive-Number: 200601/128 X-Sequence-Number: 20216 On 1/11/06, Eran L 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 =3D true > > I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it sa= ys: > > [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be e= nabled. > [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 ;)