The following bug has been logged online: Bug reference: 1256 Logged by: Bruce Modick
Email address: [EMAIL PROTECTED] 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
