Re: pg_autovacuum does not start on system - Mailing list pgsql-hackers-win32

From Matthew T. O'Connor
Subject Re: pg_autovacuum does not start on system
Date
Msg-id 41F530F9.2020205@tocr.com
Whole thread Raw
In response to Re: pg_autovacuum does not start on system startup - 8.0 Release -  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers-win32
Dave Page wrote:

>The problem with that is that with service start taking 3 minutes,
>restarting the service manually could be somewhat annoying for simple
>config changes (bear in mind that the service doesn't report that it is
>running until it has connected successfully to the database). What about
>a command line option to specify a delay? That way the user will know
>about it because they will have specified it?
>

One answer might be to  have pg_autovacuum not be so pessimistic failed
connections.  I wrote it so that pg_autovacuum exits if it fails to
connect.  Perhaps instead, when pg_autovacuum fails to connect it should
sleep for a while and then retry.   Perhaps the best plan would be a new
command line option that when used tells pg_autovacuum to continue to
retry for ever, when not used, it will still work the way it always did.

Matthew


pgsql-hackers-win32 by date:

Previous
From: "Harald Massa"
Date:
Subject: Re: pg_autovacuum does not start on system startup - 8.0 Release -
Next
From: Tom Lane
Date:
Subject: Re: long sql "in" clause crashes server process (8.0 Release)