X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A62C7D1B16A for ; Fri, 23 Jul 2004 04:38:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79448-07 for ; Fri, 23 Jul 2004 07:38:40 +0000 (GMT) Received: from anchor-post-30.mail.demon.net (anchor-post-30.mail.demon.net [194.217.242.88]) by svr1.postgresql.org (Postfix) with ESMTP id 51B4ED1B18A for ; Fri, 23 Jul 2004 04:38:32 -0300 (ADT) Received: from mailgate.bray-healthcare.com ([80.177.250.202] helo=solport.bray-healthcare.com) by anchor-post-30.mail.demon.net with esmtp (Exim 3.35 #1) id 1Bnuda-000JgJ-0U; Fri, 23 Jul 2004 07:38:38 +0000 Received: from [192.168.1.18] (helo=braydb.bray-healthcare.com) by solport.bray-healthcare.com with esmtp (Exim 3.36 #1 (Debian)) id 1Bnuda-0006Nv-00; Fri, 23 Jul 2004 08:38:38 +0100 Subject: Re: pg_autovacuum problem From: Oliver Elphick Reply-To: olly@lfix.co.uk To: Mario Soto Cc: pgsql-admin@postgresql.org In-Reply-To: <1168.200.35.199.233.1090555083.squirrel@mail.venezolanadeavaluos.com> References: <1168.200.35.199.233.1090555083.squirrel@mail.venezolanadeavaluos.com> Content-Type: text/plain Message-Id: <1090568319.5457.34.camel@braydb> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Fri, 23 Jul 2004 08:38:39 +0100 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/264 X-Sequence-Number: 14332 On Fri, 2004-07-23 at 04:58, Mario Soto wrote: > Hi i have a postgresql 7.4 in redhat 9 > > in postgresql.con > stats_row_level = true > > but whe excecute ./pg_autovacuum say > > [2004-07-22 11:53:25 PM] Error: GUC variable stats_row_level must be enabled. Have you restarted/signalled the postmaster after changing postgresql.conf? Oliver Elphick