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

Re: pg_autovacuum fails to start - 8.0 Release

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Harald Massa <ghum(at)gmx(dot)net>, pgsql-hackers-win32(at)postgresql(dot)org,"Patches (PostgreSQL)" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: pg_autovacuum fails to start - 8.0 Release
Date: 2005-01-23 01:23:34
Message-ID: 200501230123.j0N1NYB05730@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


Dave Page wrote:
>  
> 
> > -----Original Message-----
> > From: pgsql-hackers-win32-owner(at)postgresql(dot)org 
> > [mailto:pgsql-hackers-win32-owner(at)postgresql(dot)org] On Behalf 
> > Of Harald Massa
> > Sent: 20 January 2005 13:30
> > To: pgsql-hackers-win32(at)postgresql(dot)org
> > Subject: [pgsql-hackers-win32] pg_autovacuum fails to start - 
> > 8.0 Release
> > 
> > I am trying to install pg_autovacuum as a win32 service.
> > 
> > pg_autovacuum -I -N ourdomain\postgres -W secretpassword -E 
> > pgsql-8.0 -d 4
> > -L c:\ghum\data\pg_log\autovacuum.log -U postgres -P 
> > moresecretpasswords
> > 
> > when trying to start:
> > 
> > C:\Programme\PostgreSQL\8.0\bin>sc start pg_autovacuum
> > [SC] StartService FAILED 1075:
> > 
> > Der Abh?ngigkeitsdienst ist nicht vorhanden oder wurde zum 
> > L?schen markiert.
> > 
> > (english: 1075 The dependency service does not exist or has 
> > been marked for
> > deletion.  ERROR_SERVICE_DEPENDENCY_DELETED)
> 
> It appears I didn't read the docs properly when I write that bit - the dependencies parameter passed to CreateService() is supposed to be double-null terminated - a subtle point I missed :-(
> 
> The attached patch fixes this. Harald - I can email an updated .exe if you want to test, otherwise, you should be able to use the current version if you cleanup the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pg_autovacuum\DependOnService registry key.
> 
> Regards, Dave

Content-Description: pg_autovacuum.c.diff

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-patches by date

Next:From: Bruce MomjianDate: 2005-01-23 02:25:24
Subject: Re: [PATCHES] pg_autovacuum fails to start - 8.0
Previous:From: Bruce MomjianDate: 2005-01-22 22:05:55
Subject: Re: bug in 8.0 manual, section 37.6, PL/Perl Triggers

pgsql-hackers-win32 by date

Next:From: Bruce MomjianDate: 2005-01-23 02:25:24
Subject: Re: [PATCHES] pg_autovacuum fails to start - 8.0
Previous:From: Tom LaneDate: 2005-01-23 01:00:23
Subject: Re: pg_restore

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