That -- and make sure your "Secondary Logon" service is running. Also, to confirm, "Log On As" column in front of the pg service should mention the postgres (low privileged) user.
Robert, Open "Computer Management" and find the postgres service. There should be an item saying "Run As". You want that to be a non-privledged account. Typically, postgres asks you what account to use when you install it. Just make sure that account has not been granted administrative rights (you can check that under Computer Management as well)
I am running PostgreSQL 8.1.5 under Windows Server 2003 Standard edition. All has been running for weeks now, don't know if it has been restarted since we installed. Today we installed a program, Paradox database, which required a restart, and now the PostgreSQL Server service won't start with the Event description that the service cannot start by a user with administrative permsissions:
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 compromises. See the documentation for more information on how to properly start the server.
I tried checking permissions on the data folder for the postgres user, resetting the password, even re-created the user and reset perms on the data and program files. Still won't start with the event error above.
What should I look for? I am used to running PostgreSQL on our BSD boxes and have this setup for a customer.
-- Robert
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
