Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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



pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group