I have installed 8.0-beta2-dev3 on Win2k but the service will not start.
Firstly, I couldn't install postgresql as a Windows service using the insta=
ller - using the installer, I couldn't add postgresql as a Windows service =
without being a local administrator. However, if I was logged on as a local=
admin then the service would install but there was an error reported later=
on saying that the server wouldn't run because I was administrator (don't =
have a log of that error, sorry).
So I logged on as a regular user and used the installer to install postgres=
ql but NOT as a service. Then I logged on as an admin, created a regular us=
er account and used pg_ctl.exe to install the service under that account. W=
hen I start the service the Windows service manager reports that the servic=
e failed to start. The Application event log shows the following error (tho=
ugh NB the user account is a regular user, not a "Power User" or "Administr=
ator"):
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 17/09/2004
Time: 2:04:06 p.m.
User: N/A
Computer: RB-501A-08-C
Description:
The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found=
. The local computer may not have the necessary registry information or mes=
sage DLL files to display messages from a remote computer. The following in=
formation is part of the event: execution of PostgreSQL by a user with admi=
nistrative permissions is not permitted.
The server must be started under an unprivileged user ID to prevent
possible system security compromise. See the documentation for
more information on how to properly start the server.
=2E
