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

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

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Harald Massa" <ghum(at)gmx(dot)net>
Cc: <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: pg_autovacuum does not start on system startup - 8.0 Release -
Date: 2005-01-24 10:56:27
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E45285F0@ratbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
 

> -----Original Message-----
> From: Harald Massa [mailto:ghum(at)gmx(dot)net] 
> Sent: 24 January 2005 10:45
> To: Dave Page
> Cc: pgsql-hackers-win32(at)postgresql(dot)org
> Subject: Re: [pgsql-hackers-win32] pg_autovacuum does not 
> start on system startup - 8.0 Release -
> 
> Dave,
> 
> > > As said... I can start that service manually after Windows 
> > > starts talking to
> > > me. What can I do to make it run properly?
> > 
> > Hmm, I'll have to think about the best way to do that.
> 
> My impression is that Service-startup is rather 
> nondeterministic in aspects
> of timing.  
> 
> So I would suggest to integrate that sleepy workaround within 
> pg_autovacuum
> service. Just let it sleep for 'some time' ... maybe even 
> configurable ...
> before it connects. (recommended default: 180 seconds; NOT 
> microseconds and
> NOT milliseconds :))

Uh-huh :-)

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?

Regards, Dave.

Responses

pgsql-hackers-win32 by date

Next:From: Harald MassaDate: 2005-01-24 10:58:33
Subject: long sql "in" clause crashes server process (8.0 Release)
Previous:From: Harald MassaDate: 2005-01-24 10:45:27
Subject: Re: pg_autovacuum does not start on system startup - 8.0 Release -

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