Re: [pgadmin-support] Emergency - postgre is not working - Mailing list pgsql-general

From Merlin Moncure
Subject Re: [pgadmin-support] Emergency - postgre is not working
Date
Msg-id b42b73150607111119j6e233139o12d45cb37c651aba@mail.gmail.com
Whole thread Raw
In response to Re: [pgadmin-support] Emergency - postgre is not working  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: pgsql vs mysql
Next
From: John DeSoi
Date:
Subject: Re: SQL parsing suggestions?