pg_autovacuum fails to start - 8.0 Release

"Harald Massa" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
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



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.