The following bug has been logged online:

Bug reference: 1256
Logged by: Bruce Modick

Email address: modick (AT) sprynet (DOT) com

PostgreSQL version: 8.0 Beta

Operating system: Windows 2000 SP3

Description: Account problems-start as a service option install
Windows 2000/ XP

Details:

Problems with installer (for Version 8.0 Beta 2 dev 3) when you check the
'Install as a service' checkbox.

Installer cheerfully creates the postgres account and grants the 'Log on as
a service' right, but does not add the account to 'Users' group and does not
grant permission to 'Access this computer from the network' or 'Log on
locally'. These omissions cause three failure points during the install.

First error message is: "Invalid user specified: Logon Failure: Unknown
user name or bad password."

To fix this, find postgres user (Control Panel - Users and passwords) and
make postgres a Member of 'Users' group.

Second error message will be: Invalid User specified: Logon Failure: The
user has not been granted the requested logon type at this computer."

To fix this, go to Admin tools -- 'Local Security Policies' and grant the
right to 'Access this computer from the network' to the postgres account.

Third problem will be with initdb, much later in the install. Error message
will be: "Failed to create process for initdb: 1385!". Install will then
roll back.

To fix this, go to 'Local Security Polices' (again) and grant the right to
'Log on Locally' to the postgres account.

I listed all 3 error messages in series, to make for easy Google search.
Machine here is configured 'paranoia' style -- deny all permissions to all
unless needed. This probably differs from a plain vanilla Windows setup.

Installer should be changed to check/grant the two other needed permissions,
and should also add postgres user to 'Users' group when creating the
postgres account to run as a service.

Cheers.

Bruce Modick


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

It should add it to the users group.
Question: Is this by any chance a Domain Controller?=20


"Users" normally have this, I think.


Again, I beleive "Users" normally have this.


Right. If you have changed the default permissions, you will of course
need to fix that. Can't expect the installer to know about them all. We
can help a bit, though :-)


As for the first two, yes, at least chceking for them is good. I'll add
that to a tracker.
As for "Users", this should be done by default. It must be something
environment-specific.


//Magnus


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html