Re: Process won't start in Windows

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.

A. Hayee

On 1/17/07, Adam Rich <adam(dot)r(at)sbcglobal(dot)net> wrote:
>
>
> 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)
>
>
>
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Robert
> Fitzpatrick
> Sent: Tuesday, January 16, 2007 7:04 PM
> To: PostgreSQL
> Subject: [GENERAL] Process won't start in Windows
>
>
> 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
>