Re: Auto Vacuum not starting unless postgres is restarted - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: Auto Vacuum not starting unless postgres is restarted
Date
Msg-id 20060915140138.GD525@alvh.no-ip.org
Whole thread Raw
In response to Auto Vacuum not starting unless postgres is restarted  (Nick Howden <n.howden@eris.qinetiq.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: install postgres8.1 on debian
Next
From: Tom Lane
Date:
Subject: Re: Odd behaviour with WAL and pg_stop_backup