BUG #1256: Account problems-start as a service option install Windows 2000/ XP

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