Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 3C23E9FB4ED; Fri, 8 Jun 2007 01:51:42 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62917-09; Fri, 8 Jun 2007 01:51:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from pro33.abac.com (pro33.abac.com [66.226.64.34]) by postgresql.org (Postfix) with ESMTP id 528E09FB33D; Fri, 8 Jun 2007 01:51:38 -0300 (ADT) Received: from ashishk (ppp92-7.vsnl.eth.net [61.17.93.7] (may be forged)) (authenticated bits=0) by pro33.abac.com (8.13.8/8.13.8) with ESMTP id l584pO5K060702 (version=TLSv1/SSLv3 cipher=RC4-MD5 bits=128 verify=NO); Thu, 7 Jun 2007 21:51:29 -0700 (PDT) (envelope-from ashish.karalkar@info-spectrum.com) Message-ID: <002c01c7a988$09ed9500$170211ac@LIONKING.COM> From: "Ashish Karalkar" To: "Khan, Mahmood Ahram" , , , Cc: References: Subject: Re: Regarding Database Service Start Date: Fri, 8 Jun 2007 10:16:47 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0027_01C7A9B6.1F021280" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/78 X-Sequence-Number: 25746 This is a multi-part message in MIME format. ------=_NextPart_000_0027_01C7A9B6.1F021280 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Try to start with following command pg_ctl start -l logfile Lets see will it help... With Regards Ashish... ----- Original Message -----=20 From: Khan, Mahmood Ahram=20 To: pgsql-hackers-owner@postgresql.org ; pgsql-admin@postgresql.org ; = tgl@sss.pgh.pa.us=20 Cc: Ashish.Karalkar@info-spectrum.com ; aroravishal22@hotmail.com=20 Sent: Friday, June 08, 2007 10:01 AM Subject: Regarding Database Service Start Hi, =20 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 =20 C:\>pg_ctl start server starting =20 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 =20 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. =20 =20 =20 =20 Thanks & Regards =20 M.AHRAM KHAN =20 =20 ------=_NextPart_000_0027_01C7A9B6.1F021280 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Try to start with following = command
 
pg_ctl start -l logfile
 
Lets see will it help...
With Regards
Ashish...
----- Original Message -----
From:=20 Khan, Mahmood Ahram =
To: pgsql-hackers-owner@po= stgresql.org=20 ; pgsql-admin@postgresql.org= ; tgl@sss.pgh.pa.us=20
Cc: Ashish.Karalkar@info-sp= ectrum.com=20 ; aroravishal22@hotmail.com =
Sent: Friday, June 08, 2007 = 10:01=20 AM
Subject: Regarding Database = Service=20 Start

Hi,

 

Whenever I am starting = the=20 Database Service of Postgres the cursor is halting at =93Database = System Is=20 Ready=94.

It should come to the = prompt so=20 that I can start executing the commands.

But when I stop the = service the=20 cursor is halting at the Prompt. Which is=20 correct.

This is happening in = Linux &=20 Windows both.

I am specifying the = issue I am=20 facing as example below

 

C:\>pg_ctl=20 start

server=20 starting

 

C:\>LOG:  = database system=20 was shut down at 2007-06-07 16:26:20 India Standard=20 Time

LOG:  checkpoint = record is at=20 1/13B4C100

LOG:  redo record = is at=20 1/13B4C100; undo record is at 0/0; shutdown = TRUE

LOG:  next = transaction ID:=20 0/15083; next OID: 24713

LOG:  next = MultiXactId: 1;=20 next MultiXactOffset: 0

LOG:  database = system is=20 ready

 

If you see the execution = of pg_ctl=20 start you will notice that the cursor gets halted at =93LOG:  = database=20 system is ready=94.

And manually I have to = hit Enter=20 to get to the prompt. I would like to know what could be done to = overcome=20 this, ie without hitting Enter it should come to the=20 prompt.

 

 

 

 

Thanks=20 & Regards

 

M.AHRAM=20 KHAN

 

 

------=_NextPart_000_0027_01C7A9B6.1F021280--