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

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: [pgadmin-support] Emergency - postgre is not working
Дата
Msg-id b42b73150607111119j6e233139o12d45cb37c651aba@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [pgadmin-support] Emergency - postgre is not working  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jan Wieck
Дата:
Сообщение: Re: pgsql vs mysql
Следующее
От: John DeSoi
Дата:
Сообщение: Re: SQL parsing suggestions?