Re: Regarding Database Service Start

From: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
To: Mahmood(dot)Khan(at)in(dot)unisys(dot)com, pgsql-admin(at)postgresql(dot)org
Cc: Ashish(dot)Karalkar(at)info-spectrum(dot)com
Subject: Re: Regarding Database Service Start
Date: 2007-06-08 06:02:07
Message-ID: BAY123-F403AB3DD8964AD917AC16FA9250@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc Cousin 2007-06-08 08:06:39 Re: 8.3 and 8.4 feature list
Previous Message Ashish Karalkar 2007-06-08 04:46:47 Re: Regarding Database Service Start