pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
install postgre on windows XP, service failed to start.
5+ messages / 4 participants
[nested] [flat]

* install postgre on windows XP, service failed to start.
@ 2006-05-13 21:29  Jeff Zhong <jeff.zhong@gmail.com>
  0 siblings, 2 replies; 5+ messages in thread

From: Jeff Zhong @ 2006-05-13 21:29 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: install postgre on windows XP, service failed to start.
@ 2006-05-13 23:18  louis gonzales <gonzales@linuxlouis.net>
  parent: Jeff Zhong <jeff.zhong@gmail.com>
  1 sibling, 0 replies; 5+ messages in thread

From: louis gonzales @ 2006-05-13 23:18 UTC (permalink / raw)
  To: Jeff Zhong <jeff.zhong@gmail.com>; +Cc: pgsql-admin

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.



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: install postgre on windows XP, service failed to start.
@ 2006-05-14 00:49  Jaime Casanova <systemguards@gmail.com>
  parent: Jeff Zhong <jeff.zhong@gmail.com>
  1 sibling, 1 reply; 5+ messages in thread

From: Jaime Casanova @ 2006-05-14 00:49 UTC (permalink / raw)
  To: Jeff Zhong <jeff.zhong@gmail.com>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: install postgre on windows XP, service failed to start.
@ 2006-05-14 11:25  Andy Shellam <andy@andycc.net>
  parent: Jaime Casanova <systemguards@gmail.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Andy Shellam @ 2006-05-14 11:25 UTC (permalink / raw)
  To: jeff.zhong@gmail.com; +Cc: Jaime Casanova <systemguards@gmail.com>; pgsql-admin

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)
>
>





^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: install postgre on windows XP, service failed to start.
@ 2006-05-14 11:28  Andy Shellam <andy@andycc.net>
  parent: Andy Shellam <andy@andycc.net>
  0 siblings, 0 replies; 5+ messages in thread

From: Andy Shellam @ 2006-05-14 11:28 UTC (permalink / raw)
  To: pgsql-admin

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!
>
>





^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2006-05-14 11:28 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-05-13 21:29 install postgre on windows XP, service failed to start. Jeff Zhong <jeff.zhong@gmail.com>
2006-05-13 23:18 ` louis gonzales <gonzales@linuxlouis.net>
2006-05-14 00:49 ` Jaime Casanova <systemguards@gmail.com>
2006-05-14 11:25   ` Andy Shellam <andy@andycc.net>
2006-05-14 11:28     ` Andy Shellam <andy@andycc.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox