Re: pg_autovacuum does not start on system startup - 8.0 Release -

 

> -----Original Message-----
> From: Matthew T. O'Connor [mailto:[email protected]] 
> Sent: 24 January 2005 17:32
> To: Dave Page
> Cc: Harald Massa; [email protected]
> Subject: Re: [pgsql-hackers-win32] pg_autovacuum does not 
> start on system startup - 8.0 Release -
> 
> 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.

Yeah, that's essentially what we're testing at the moment. If the
connection fails, it waits 30 seconds and trys again before bailing out
(though it only does it in Windows Service mode as the is the most
un-controllable startup type). It's a pretty un-invasive patch that
avoids adding command line options etc.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [email protected] so that your
      message can get through to the mailing list cleanly