Обсуждение: install postgre on windows XP, service failed to start.

Поиск
Список
Период
Сортировка

install postgre on windows XP, service failed to start.

От
"Jeff Zhong"
Дата:
I installing postgre SQL on Windowx XP

Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) failed to start.  Verify that you have sufficient privileges to start system services.

I got this error when I try to install postgresql on windowx XP

i am using the installer version which is from:

ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip

The user account that the service is created by the installer. I just wonder why it cannot start the service with that account(postgres)

any hits are appreciated

Regards
Jeff

Re: install postgre on windows XP, service failed to start.

От
"Jaime Casanova"
Дата:
On 5/13/06, Jeff Zhong <jeff.zhong@gmail.com> wrote:
> I installing postgre SQL on Windowx XP
>
> Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database Server
> 8.1' (pgsql-8.1) failed to start.  Verify that you have sufficient
> privileges to start system services.
>
> I got this error when I try to install postgresql on windowx XP
>
> i am using the installer version which is from:
>
> ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip
>
> The user account that the service is created by the installer. I just wonder
> why it cannot start the service with that account(postgres)
>
> any hits are appreciated
>
> Regards
> Jeff
>

the installation completes? if so, try to start the service by hand
and show the error (eventlog should have a description)


--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

Re: install postgre on windows XP, service failed to start.

От
Andy Shellam
Дата:
Make sure that the account under which you've installed it (i.e your
user account) has full Administrator priveledges on the machine -
otherwise you won't be able to assign the "Log on as service" right to
the postgres account - it might be worth checking if this is set anyway
- run services.msc and have a browse for the local policy "Log on as a
service".  Your postgres service user should be added to it.

Andy

Jaime Casanova wrote:
> On 5/13/06, Jeff Zhong <jeff.zhong@gmail.com> wrote:
>> I installing postgre SQL on Windowx XP
>>
>> Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database
>> Server
>> 8.1' (pgsql-8.1) failed to start.  Verify that you have sufficient
>> privileges to start system services.
>>
>> I got this error when I try to install postgresql on windowx XP
>>
>> i am using the installer version which is from:
>>
>> ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip
>>
>>
>> The user account that the service is created by the installer. I just
>> wonder
>> why it cannot start the service with that account(postgres)
>>
>> any hits are appreciated
>>
>> Regards
>> Jeff
>>
>
> the installation completes? if so, try to start the service by hand
> and show the error (eventlog should have a description)
>
>



Re: install postgre on windows XP, service failed to start.

От
Andy Shellam
Дата:
Sorry, you need to run "secpol.msc" to check the local policy, NOT
"services.msc" - my mistake.

Andy

Andy Shellam wrote:
> Make sure that the account under which you've installed it (i.e your
> user account) has full Administrator priveledges on the machine -
> otherwise you won't be able to assign the "Log on as service" right to
> the postgres account - it might be worth checking if this is set
> anyway - run services.msc and have a browse for the local policy "Log
> on as a service".  Your postgres service user should be added to it.
>
> Andy
>
> Jaime Casanova wrote:
>> On 5/13/06, Jeff Zhong <jeff.zhong@gmail.com> wrote:
>>> I installing postgre SQL on Windowx XP
>>>
>>> Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database
>>> Server
>>> 8.1' (pgsql-8.1) failed to start.  Verify that you have sufficient
>>> privileges to start system services.
>>>
>>> I got this error when I try to install postgresql on windowx XP
>>>
>>> i am using the installer version which is from:
>>>
>>> ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip
>>>
>>>
>>> The user account that the service is created by the installer. I
>>> just wonder
>>> why it cannot start the service with that account(postgres)
>>>
>>> any hits are appreciated
>>>
>>> Regards
>>> Jeff
>>>
>>
>> the installation completes? if so, try to start the service by hand
>> and show the error (eventlog should have a description)
>>
>>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org
>
> !DSPAM:14,4467140934491946621466!
>
>



Re: install postgre on windows XP, service failed to start.

От
louis gonzales
Дата:
Jeff Zhong wrote:

> I installing postgre SQL on Windowx XP
>
> Product: PostgreSQL 8.1 -- Error 1920. Service 'PostgreSQL Database
> Server 8.1' (pgsql-8.1) failed to start.  Verify that you have
> sufficient privileges to start system services.
>
> I got this error when I try to install postgresql on windowx XP
>
> i am using the installer version which is from:
>
> ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip
> <ftp://ftp5.us.postgresql.org/pub/PostgreSQL/binary/v8.1.3/win32/postgresql-8.1.3-1.zip>
>
> The user account that the service is created by the installer. I just
> wonder why it cannot start the service with that account(postgres)
>
> any hits are appreciated
>
> Regards
> Jeff

What user account are you logged in with?  postgres the user must be
allowed to logon as a service.  That might be a good place to start looking.