Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3C06D9FB5F4 for ; Fri, 8 Jun 2007 03:02:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 63332-07 for ; Fri, 8 Jun 2007 03:02:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from bay0-omc1-s39.bay0.hotmail.com (bay0-omc1-s39.bay0.hotmail.com [65.54.246.111]) by postgresql.org (Postfix) with ESMTP id 877DD9FA49E for ; Fri, 8 Jun 2007 03:02:12 -0300 (ADT) Received: from hotmail.com ([207.46.11.120]) by bay0-omc1-s39.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.2668); Thu, 7 Jun 2007 23:02:09 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 7 Jun 2007 23:02:09 -0700 Message-ID: Received: from 207.46.11.123 by by123fd.bay123.hotmail.msn.com with HTTP; Fri, 08 Jun 2007 06:02:07 GMT X-Originating-IP: [59.160.193.34] X-Originating-Email: [aroravishal22@hotmail.com] X-Sender: aroravishal22@hotmail.com In-Reply-To: From: "Vishal Arora" To: Mahmood.Khan@in.unisys.com, pgsql-admin@postgresql.org Cc: Ashish.Karalkar@info-spectrum.com Subject: Re: Regarding Database Service Start Date: Fri, 08 Jun 2007 06:02:07 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 08 Jun 2007 06:02:09.0349 (UTC) FILETIME=[8CA80750:01C7A992] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.621 tagged_above=0 required=5 tests=AWL=-0.177, BAYES_05=-1.11, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, MSGID_FROM_MTA_HEADER=0 X-Spam-Level: X-Archive-Number: 200706/79 X-Sequence-Number: 25747 You can try running the service in background . using '&' in linux environment. >From: "Khan, Mahmood Ahram" >To: >,, >CC: , >Subject: Regarding Database Service Start >Date: Fri, 8 Jun 2007 10:01:53 +0530 > >Hi, > > > >Whenever I am starting the Database Service of Postgres the cursor is >halting at "Database System Is Ready". > >It should come to the prompt so that I can start executing the commands. > >But when I stop the service the cursor is halting at the Prompt. Which >is correct. > >This is happening in Linux & Windows both. > >I am specifying the issue I am facing as example below > > > >C:\>pg_ctl start > >server starting > > > >C:\>LOG: database system was shut down at 2007-06-07 16:26:20 India >Standard Time > >LOG: checkpoint record is at 1/13B4C100 > >LOG: redo record is at 1/13B4C100; undo record is at 0/0; shutdown TRUE > >LOG: next transaction ID: 0/15083; next OID: 24713 > >LOG: next MultiXactId: 1; next MultiXactOffset: 0 > >LOG: database system is ready > > > >If you see the execution of pg_ctl start you will notice that the cursor >gets halted at "LOG: database system is ready". > >And manually I have to hit Enter to get to the prompt. I would like to >know what could be done to overcome this, ie without hitting Enter it >should come to the prompt. > > > > > > > > > >Thanks & Regards > > > >M.AHRAM KHAN > > > > > _________________________________________________________________ Get a preview of Live Earth, the hottest event this summer - only on MSN http://liveearth.msn.com?source=msntaglineliveearthhm