followups : Database Server in Recovery mode!

<tt>Hi i tried to stop it later</tt><br /><tt>and following is what is happening</tt><tt></tt><p><tt>regds</tt><br
/><tt>mallah.</tt><br/><tt></tt> <tt></tt><p><tt>bash-2.03$ pg_ctl -D /var/lib/pgsql/data stop</tt><br /><tt>waiting
forpostmaster to shut down...................................................</tt><br /><tt>.............
failed</tt><br/><tt>pg_ctl: postmaster does not shut down</tt><br /><tt>bash-2.03$</tt><tt></tt><p><tt>then i
did:</tt><tt></tt><p><tt>bash-2.03$pg_ctl -D /var/lib/pgsql/data stop  -m immediate</tt><br /><tt>waiting for
postmasterto shut down....done</tt><br /><b><tt><font color="#000099">postmaster successfully shut
down</font></tt></b><br/><tt>bash-2.03$ pg_ctl -D /var/lib/pgsql/data start</tt><br /><tt>postmaster successfully
started</tt><br/><tt>bash-2.03$ DEBUG:  database system was interrupted at 2002-04-25 12:10:43 IST</tt><br
/><tt>DEBUG: CheckPoint record at (91, 2768917524)</tt><br /><tt>DEBUG:  Redo record at (91, 2768306852); Undo record
at(91, 2718752328); Shutdown FALSE</tt><br /><tt>DEBUG:  NextTransactionId: 10070150; NextOid: 86521966</tt><br
/><b><tt><fontcolor="#990000">DEBUG:  database system was not properly shut down; automatic recovery in
progress...</font></tt></b><br/><tt>DEBUG:  redo starts at (91, 2768306852)</tt><br /><tt>DEBUG:  open(logfile 91 seg
166)failed: No such file or directory</tt><br /><tt>DEBUG:  redo done at (91, 2785015440)</tt><br /><tt>The Data Base
Systemis starting up</tt><tt></tt><p><tt>bash-2.03$</tt><br /><tt></tt> <tt></tt><p><tt>on connesting from a
cleint:</tt><tt></tt><p><tt>[rmallah@system11rmallah]$ psql -h 130.94.22.209 -Utradein  tradein_clients</tt><br
/><tt>psql:The Data Base System is starting up</tt><br /><tt>[rmallah@system11 rmallah]$</tt><br /><tt></tt>  <br
/><tt></tt> <tt></tt><p>RajeshKumar Mallah wrote: <blockquote type="CITE">Hi Friends <p>please help. <p>my database
serverhas gone in recovery mode for some <br />reasons i donot know. <p>what is the possible steps one shud take to
bringthe database <br />up to an usable state in minimum time. <br />  <p><tt>Below is the message when i try to
connect.</tt><p><tt>thethe out put of ps in the database server.</tt><br />  <p><tt>regds</tt><br /><tt>mallah.</tt><br
/> <br />  <p><tt>[rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein  tradein_clients</tt><br /><tt>psql: The
DataBase System is in recovery mode</tt><br /><tt>[rmallah@system11 rmallah]$</tt><br />  <br />  <br /> 
<p><tt>[root@linux10320data]# ps auxwww | grep post</tt><br /><tt>postgres  1839  0.0  0.0 138992 856 ?        S   
Apr12  2:43 /usr/bin/postmaster -D /var/lib/pgsql/data</tt><br /><tt>postgres  3901  6.0  1.4 141068 15248 ?      D   
12:05  1:29 postgres: tradein tradein_clients 130.94.20.27 COPY</tt><br /><tt>root      5862  0.0  0.0  1360  512
pts/3   S    12:29   0:00 grep post</tt><br /><tt>[root@linux10320 data]#</tt><br /> </blockquote>