X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 967389FA32D for ; Sun, 14 May 2006 08:25:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 66130-05 for ; Sun, 14 May 2006 08:25:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id EEADE9F9430 for ; Sun, 14 May 2006 08:25:45 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1356 helo=[127.0.0.1]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FfEjH-00070r-EY; Sun, 14 May 2006 12:25:43 +0100 Message-ID: <446713AE.4020103@andycc.net> Date: Sun, 14 May 2006 12:25:34 +0100 From: Andy Shellam Reply-To: andy@andycc.net Organization: the mail network User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: jeff.zhong@gmail.com CC: Jaime Casanova , pgsql-admin@postgresql.org Subject: Re: install postgre on windows XP, service failed to start. References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/169 X-Sequence-Number: 21701 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 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) > >