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 installer -
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 postgresql but NOT
as a service. Then I logged on as an admin, created a regular user account and used
pg_ctl.exe to install the service under that account. When I start the service the
Windows service manager reports that the service failed to start. The Application
event log shows the following error (though NB the user account is a regular user, not
a "Power User" or "Administrator"):
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 message DLL files to
display messages from a remote computer. The following information is part of the
event: execution of PostgreSQL by a user with administrative 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.
.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
