pg_autovacuum fails to start - 8.0 Release

From: "Harald Massa" <ghum(at)gmx(dot)net>
To: pgsql-hackers-win32(at)postgresql(dot)org
Subject: pg_autovacuum fails to start - 8.0 Release
Date: 2005-01-20 13:29:47
Message-ID: 24172.1106227787@www1.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32

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)

if I check dependencies...

C:\Programme\PostgreSQL\8.0\bin>sc query pg_autovacuum
SERVICE_NAME: pg_autovacuum
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED

(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 1077 (0x435)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

C:\Programme\PostgreSQL\8.0\bin>sc EnumDepend pg_autovacuum
Enum: entriesRead = 0

C:\Programme\PostgreSQL\8.0\bin>sc EnumDepend pgsql-8.0
Enum: entriesRead = 1

SERVICE_NAME: pg_autovacuum
DISPLAY_NAME: PostgreSQL Auto Vacuum
TYPE : 10 WIN32_OWN_PROCESS
STATE : 1 STOPPED

(NOT_STOPPABLE,NOT_PAUSABLE,IGNORES_SHUTDOWN)
WIN32_EXIT_CODE : 1075 (0x433)
SERVICE_EXIT_CODE : 0 (0x0)
CHECKPOINT : 0x0
WAIT_HINT : 0x0

I learn that pgsql-8.0 sees pg_autovacuum as a dependand service, but
pg_autovacuum does not see itself as debendand.

If I look within services.msc, pg_autovacuum really has Postgresql as
service it is dependend on.

(and, yes pgsql-8.0 is reallly present AND running)

what can I do to make it work?

Harald

(btw: the logfile contains:

[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO: Printing
command_args
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->host=(null)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->port=(null)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->username=postgres
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->password=faghimwyo
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->logfile=c:\ghum\data\pg_log\autovacuum.log
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->install_as_service=1
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->remove_as_service=0
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->service_dependencies=pgsql-8.0
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->service_user=suedvers\postgres
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->service_password=ucikguxMosh
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->sleep_base_value=300
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->sleep_scaling_factor=2.000000
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->vacuum_base_threshold=1000
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->vacuum_scaling_factor=2.000000
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->analyze_base_threshold=500
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->analyze_scaling_factor=1.000000
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_delay=(default)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_hit=(default)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_miss=(default)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_page_dirty=(default)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO:
args->av_vacuum_cost_limit=(default)
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO: args->debug=4
[2005-01-20 14:18:19 Westeuropäische Normalzeit] INFO: Successfully
installed Windows service

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Dave Page 2005-01-20 15:28:49 Re: pg_autovacuum fails to start - 8.0 Release
Previous Message Niederland 2005-01-20 08:19:36 Re: pg_restore