X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 0F6E99FB24D for ; Fri, 15 Sep 2006 11:03:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 94707-09 for ; Fri, 15 Sep 2006 14:03:26 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from lists.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id C75259FB1FF for ; Fri, 15 Sep 2006 11:03:25 -0300 (ADT) Received: from alvh.no-ip.org (201-221-217-241.bk12-dsl.surnet.cl [201.221.217.241]) (authenticated bits=0) by lists.commandprompt.com (8.13.7/8.13.6) with ESMTP id k8FE2W25032645; Fri, 15 Sep 2006 07:02:33 -0700 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 6CA1DC9E0B6; Fri, 15 Sep 2006 10:01:42 -0400 (CLT) Date: Fri, 15 Sep 2006 10:01:39 -0400 From: Alvaro Herrera To: Nick Howden Cc: pgsql-admin@postgresql.org Subject: Re: Auto Vacuum not starting unless postgres is restarted Message-ID: <20060915140138.GD525@alvh.no-ip.org> Mail-Followup-To: Nick Howden , pgsql-admin@postgresql.org References: <200609151311.46023.n.howden@eris.qinetiq.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200609151311.46023.n.howden@eris.qinetiq.com> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: ClamAV version 0.88.3, clamav-milter version 0.88.3 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (lists.commandprompt.com [192.168.2.159]); Fri, 15 Sep 2006 07:02:35 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/152 X-Sequence-Number: 23066 Nick Howden wrote: > Hi, > > On startup we get an error in the postgres log that the Autovacuum process has > failed to start -- "autovacuum not started because of misconfiguration". > However, if we do a restart (/etc/init/d/postgresql8.1 restart) then the > autovacuum starts fine. > > Does anybody have any idea what the problem might be? Do you have a message about failure to start the statistics collector as well (on the first try), which is missing on the reattempt? It may be that the startup firewall policy (at the time the PostgreSQL is first started) is restrictive, and is relaxed later on the boot process. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support