Re: pg_autovacuum fails to start - 8.0 Release

> -----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