Re: [pgadmin-support] Emergency - postgre is not working

On 7/11/06, Harald Armin Massa <haraldarminmassa@gmail.com> wrote:
> Propblem gets clearer. I had similiar symptoms before; so my rough guess is:
> your postgres user did loose a privilege.
>
> Technical background:
> the postgres-account is a low privileged user, which logs on automatically
> when the service starts up. So he needs the privilege "log on as service"
>
> And I think that your postgres account loosed that privilege.
>
> So I recommend to try the following steps:
>
> a) startup the Editor of user accounts (within control panel)
> b) change the password of the postgres user account to something you know
> c) restart services.msc, and open the Properties of the Postgres Services
> d) go to the logon page, and enter the new password you just gave to this
> account (step b)
> e) try to start the service again from the service control panel
>
> With entering the logon information again to the "logon-tab" of the service
> properties dialog, you are re-giving that privilege.

I'm pretty sure that simply going into properties of the service and
clicking ok will (re)grant the log on as service right.

merlin