Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id C79B89FB7C5 for ; Fri, 18 May 2007 02:54:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 78656-08 for ; Fri, 18 May 2007 02:54:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from rrmailscan3.safenetbox.biz (unknown [203.25.40.75]) by postgresql.org (Postfix) with ESMTP id ABEC89FB7A9 for ; Fri, 18 May 2007 02:54:13 -0300 (ADT) Received: from rrmailscan3.safenetbox.biz (rrmailscan3.safenetbox.biz [127.0.0.1]) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 45C9A1D48460 for ; Fri, 18 May 2007 15:54:12 +1000 (EST) Received: from [127.0.0.1] (online4-new.lnk.telstra.net [139.130.169.227]) (Authenticated sender: remote) by rrmailscan3.safenetbox.biz (Postfix) with ESMTP id 51B301D4843D for ; Fri, 18 May 2007 15:54:11 +1000 (EST) Message-ID: <464D3F76.4040302@autoledgers.com.au> Date: Fri, 18 May 2007 13:53:58 +0800 From: Paul Lambert User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Postgres error 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: 200705/178 X-Sequence-Number: 25498 Ritu Khetan wrote: > > > > > Hi Paul, > > The service does not start , hence we tried it through the command prompt > to check what is the error. > > Any thoughts? > > Regards, > Ritu > > > Are you presented with any particular error when you try starting the service? Have you checked the event viewer log? If you check in task manager and there are NO postmaster processes running, then check the data directory and delete the postmaster.pid file if it exists, then give the service a restart. Failing that, check the logs in data/pg_log. Check that the user the pg service is running under hasn't lost write permissions to the directory. (E:/crisilfe/crisil/pgsql/data) -- Paul Lambert Database Administrator AutoLedgers