BUG #2635: manual service registration after install - Mailing list pgsql-bugs

From
Subject BUG #2635: manual service registration after install
Date
Msg-id 200609181435.k8IEZkJB001874@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2635
Logged by:
Email address:      michael.eggerichs@henrichsen.de
PostgreSQL version: 8.1.3
Operating system:   Windows
Description:        manual service registration after install
Details:

1. Manual create user "postgres" with password "password"

2. Join user "postgres" to group "Benutzer" (German)

3. Give user "postgres" the right "SeServiceLogonRight"

4. Installer (without DOSERVICE=1):
'MSIEXEC /i "H:\postgresql-8.1-int.msi" /qn INTERNALLAUNCH=1 DODBINIT=1
DOSERVICE=0 NOSHORTCUTS=1 ADDLOCAL=server,psql,pgadmin,psqlodbc
SERVICEDOMAIN=%COMPUTERNAME% SERVICEACCOUNT=postgres
SERVICEPASSWORD=password SERVICENAME=pgsql-8.1
BASEDIR="C:\MyApps\dbms\POSTGRES" SUPERUSER=su SUPERPASSWORD=supassword
ENCODING=LATIN1 TRANSFORMS=:lang_de'

5. Manual register service with:
'pg_ctl register -U "postgres" -P "password" -N "pgsql-8.1" -D
"C:\MyApps\dbms\POSTGRES\data\"'

6. Try to start service in service manager -> didn't run
-> Checking service entries in registry -> ImagePath:
'C:\MyApps\dbms\POSTGRES\bin/pg_ctl.exe runservice -N "pgsql-8.1" -D
"C:/MyApps/dbms/POSTGRES/data"'
(Backslashes turned into slashes - not so with DOSERVICE=1 !!!)


What's wrong with that?

I can't find description for additional registration steps in
documentation.

PS: Creating a second service after installing with installer and
DOSERVICE=1 seems to work.

pgsql-bugs by date:

Previous
From: "Massimo Fidanza"
Date:
Subject: BUG #2632: createuser language poblem
Next
From: "Ross Elliott"
Date:
Subject: Re: BUG #2631: database locking problem