Skip site navigation (1) Skip section navigation (2)

Re: pg_autovacuum Win32 Service startup delay

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: pg_autovacuum Win32 Service startup delay
Date: 2005-01-24 23:57:54
Message-ID: 27181.1106611074@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-patches
"Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> writes:
> 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.

Hm.  In event that the system crashed beforehand, it could require much
more than 30 seconds to finish replaying the old WAL log.  So the above
doesn't seem super robust to me.  Would it be reasonable to try every 30
seconds for five minutes, or some such?  (Five minutes at least has a
defensible rationale, ie it's the default checkpoint interval and we
expect we can replay the log at least as fast as it was created
initially.)

			regards, tom lane

In response to

Responses

pgsql-patches by date

Next:From: Neil ConwayDate: 2005-01-25 00:22:23
Subject: Re: LRU
Previous:From: Tom LaneDate: 2005-01-24 23:43:19
Subject: Re: LRU

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group