X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 908353A47BD for ; Thu, 25 Nov 2004 19:57:46 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 19539-01 for ; Thu, 25 Nov 2004 19:57:43 +0000 (GMT) Received: from mta02.onolab.com (smtp.ono.com [62.42.230.12]) by svr1.postgresql.org (Postfix) with ESMTP id 6EF053A47B7 for ; Thu, 25 Nov 2004 19:57:43 +0000 (GMT) Received: from [192.168.1.101] (84.122.163.142) by mta02.onolab.com (7.1.016.11) (authenticated as juanmime) id 415C438A0045A7EE; Thu, 25 Nov 2004 20:57:33 +0100 Message-ID: <41A6392F.5070605@ono.com> Date: Thu, 25 Nov 2004 20:57:35 +0100 From: Juan Miguel User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.1) Gecko/20040707 X-Accept-Language: es-es, en-us, en MIME-Version: 1.0 To: James Nyunt Cc: pgsql-admin@postgresql.org Subject: Re: postgres in windows xP References: <000001c4d2b5$6fe700a0$6401a8c0@laptop> In-Reply-To: <000001c4d2b5$6fe700a0$6401a8c0@laptop> Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/191 X-Sequence-Number: 15574 I suggest that you try with Postgresql 8. It's already in beta phase, but is Windows native, and does not need cygwin. The performance of postgres with cygwin is poor. > Hi > > I have been trying to get postgres in windows through cygwin. No > success yet. I followed all the instructions in postgresql-7.4.5 step > by step. But the last a few steps, particularly, in step 9, /cygrunsrv > –S postmaster / doesn’t work. I could not start postmaster as service > at all. I have added postgres to log on as service in secpol.msc. I > can also see postmaster in service, in postmaster’s property, log in > tab, I can also see postgres. > > Ok, here are a few messages, I got, I tried both commands cygrunsrv > and net start. > > When I run as admin user , who got admin right, I got these errors > > admin@laptop ~ > > $ cygrunsrv -S postmaster > > cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error 1062: > > The service has not been started. > > admin@laptop ~ > > $ net start postmaster > > The postmaster service is starting. > > The postmaster service could not be started. > > A system error has occurred. > > System error 1067 has occurred. > > The process terminated unexpectedly. > > When I run as postgres user, who got limited right, I got these > > postgres@laptop ~ > > $ cygrunsrv -S postmaster > > cygrunsrv: Error starting a service: OpenSCManager: Win32 error 5: > > Access is denied. > > postgres@laptop ~ > > $ net start postmaster > > System error 5 has occurred. > > Access is denied. > > Any Help please, > > With many thanks > > James >