Thread: Re: [pgsql-hackers-win32] pg_autovacuum fails to start - 8.0 Release

> -----Original Message-----
> From: pgsql-hackers-win32-owner@postgresql.org
> [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> Of Harald Massa
> Sent: 20 January 2005 13:30
> To: pgsql-hackers-win32@postgresql.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()
issupposed 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
touse the current version if you cleanup the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pg_autovacuum\DependOnServiceregistry key. 

Regards, Dave

Dave,

thank you very much for fixing the problem. Just to have it in the
googleable space:

> you should be able to use the current version if
> you cleanup
the

>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pg_autovacuum\DependOnService
>registry key.

That is of no use. The service fails to start with exactly the same error
message. (But, at least, I could see the problem within the registry :))

Harald

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@postgresql.org
> > [mailto:pgsql-hackers-win32-owner@postgresql.org] On Behalf
> > Of Harald Massa
> > Sent: 20 January 2005 13:30
> > To: pgsql-hackers-win32@postgresql.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
ableto use the current version if you cleanup the
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\pg_autovacuum\DependOnServiceregistry 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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073