| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Nick Howden <n(dot)howden(at)eris(dot)qinetiq(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Auto Vacuum not starting unless postgres is restarted |
| Date: | 2006-09-15 14:01:39 |
| Message-ID: | 20060915140138.GD525@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-09-15 14:02:30 | Re: install postgres8.1 on debian |
| Previous Message | Tom Lane | 2006-09-15 13:41:01 | Re: [ADMIN] Vacuum error on database postgres |