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 749359DC865 for ; Wed, 11 Jan 2006 06:11:29 -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 38842-04 for ; Wed, 11 Jan 2006 06:11:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by postgresql.org (Postfix) with ESMTP id 55E1D9DC813 for ; Wed, 11 Jan 2006 06:11:27 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i3so96520wra for ; Wed, 11 Jan 2006 02:11:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=AwWRLkG2M+W0dOnA9KmMt+OqJ+MfN36UwCfSJeQFL3K62eQM1sINlCWVvrPD83MgYb/2OZEld0HvpoDoD8xkIjY3Cthm6+72HMJh3w1jBf5kIPtDSfTxbCjWN1Sl2O1PRd0Pfzr0cJTVnC6GXMyYcf26uzY25mgKTU0PX8BxyT4= Received: by 10.54.65.16 with SMTP id n16mr201304wra; Wed, 11 Jan 2006 02:11:29 -0800 (PST) Received: by 10.54.80.18 with HTTP; Wed, 11 Jan 2006 02:11:29 -0800 (PST) Message-ID: Date: Wed, 11 Jan 2006 12:11:29 +0200 From: Eran L To: pgsql-admin@postgresql.org Subject: pg_autovacuum MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200601/108 X-Sequence-Number: 20196 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 says= : [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be ena= bled. [2006-01-11 12:11:07 IST] Please fix the problems and try a= gain. What more needs to be done ? TIA, Eran