pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Regarding Database Service Start
3+ messages / 3 participants
[nested] [flat]

* Regarding Database Service Start
@ 2007-06-08 04:31  Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Khan, Mahmood Ahram @ 2007-06-08 04:31 UTC (permalink / raw)
  To: pgsql-hackers-owner@postgresql.org; pgsql-admin; tgl@sss.pgh.pa.us; +Cc: Ashish.Karalkar@info-spectrum.com; aroravishal22@hotmail.com

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

 

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding Database Service Start
@ 2007-06-08 04:46  Ashish Karalkar <ashish.karalkar@info-spectrum.com>
  parent: Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Ashish Karalkar @ 2007-06-08 04:46 UTC (permalink / raw)
  To: Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>; pgsql-hackers-owner@postgresql.org; pgsql-admin; tgl@sss.pgh.pa.us; +Cc: aroravishal22@hotmail.com

Try to start with following command

pg_ctl start -l logfile

Lets see will it help...
With Regards
Ashish...
  ----- Original Message ----- 
  From: Khan, Mahmood Ahram 
  To: pgsql-hackers-owner@postgresql.org ; pgsql-admin@postgresql.org ; tgl@sss.pgh.pa.us 
  Cc: Ashish.Karalkar@info-spectrum.com ; aroravishal22@hotmail.com 
  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

   

   

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Regarding Database Service Start
@ 2007-06-08 06:02  Vishal Arora <aroravishal22@hotmail.com>
  parent: Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Vishal Arora @ 2007-06-08 06:02 UTC (permalink / raw)
  To: Mahmood.Khan@in.unisys.com; pgsql-admin; +Cc: Ashish.Karalkar@info-spectrum.com

You can try running the service in background . using '&' in linux 
environment.


>From: "Khan, Mahmood Ahram" <Mahmood.Khan@in.unisys.com>
>To: 
><pgsql-hackers-owner@postgresql.org>,<pgsql-admin@postgresql.org>,<tgl@sss.pgh.pa.us>
>CC: <Ashish.Karalkar@info-spectrum.com>,<aroravishal22@hotmail.com>
>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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2007-06-08 06:02 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-08 04:31 Regarding Database Service Start Khan, Mahmood Ahram <Mahmood.Khan@in.unisys.com>
2007-06-08 04:46 ` Ashish Karalkar <ashish.karalkar@info-spectrum.com>
2007-06-08 06:02 ` Vishal Arora <aroravishal22@hotmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox