pg_autovacuum fails to start - 8.0 Release

Поиск
Список
Период
Сортировка
От Harald Massa
Тема pg_autovacuum fails to start - 8.0 Release
Дата
Msg-id 24172.1106227787@www1.gmx.net
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: pginstaller RC5-2
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: [PATCHES] pg_autovacuum fails to start - 8.0 Release