Re: pg_autovacuum Win32 Service startup delay - Mailing list pgsql-patches

From Matthew T. O'Connor
Subject Re: pg_autovacuum Win32 Service startup delay
Date
Msg-id 41F5BA7D.7090207@zeut.net
Whole thread Raw
In response to pg_autovacuum Win32 Service startup delay  ("Dave Page" <dpage@vale-housing.co.uk>)
Responses Re: pg_autovacuum Win32 Service startup delay
Re: pg_autovacuum Win32 Service startup delay
List pgsql-patches
Dave Page wrote:

>When starting as a service at boot time on Windows, pg_autovacuum may
>fail to start because the PostgreSQL service is still starting up. This
>patch causes the service to attempt a second connection 30 seconds after
>the initial connection failure before giving up entirely.
>
>

In the windows service world, is there any reason pg_autovacuum should
ever give up?  The reason I had it give up was so that it didn't
accidently run against a different postgresql instance.  I don't think
that will happen in the windows service world.  I think it should keep
trying to do it's job until it's told to exit.

Matthew


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: add regression test for #1433
Next
From: Kris Jurka
Date:
Subject: add soundex difference function to contrib/fuzzystrmatch