Re: pg_autovacuum fails to start - 8.0 Release
Bruce Momjian <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.devel.patches |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] > > [mailto:[email protected]] On Behalf > > Of Harald Massa > > Sent: 20 January 2005 13:30 > > To: [email protected] > > 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 [email protected] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster