Re: Regarding Database Service Start - Mailing list pgsql-admin

From Ashish Karalkar
Subject Re: Regarding Database Service Start
Date
Msg-id 002c01c7a988$09ed9500$170211ac@LIONKING.COM
Whole thread Raw
In response to Regarding Database Service Start  ("Khan, Mahmood Ahram" <Mahmood.Khan@in.unisys.com>)
List pgsql-admin
Try to start with following command
 
pg_ctl start -l logfile
 
Lets see will it help...
With Regards
Ashish...
----- Original Message -----
Sent: Friday, June 08, 2007 10:01 AM
Subject: Regarding Database Service Start

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

 

 

pgsql-admin by date:

Previous
From: "Khan, Mahmood Ahram"
Date:
Subject: Regarding Database Service Start
Next
From: "Vishal Arora"
Date:
Subject: Re: Regarding Database Service Start