Re: pg_autovacuum fails to start - 8.0 Release

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