Database Server in Recovery mode! - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Database Server in Recovery mode!
Date
Msg-id 3CC7A7AC.F995E2BB@trade-india.com
Whole thread Raw
List pgsql-sql
Hi Friends <p>please help. <p>my database server has gone in recovery mode for some <br />reasons i donot know.
<p>whatis the possible steps one shud take to bring the database <br />up to an usable state in minimum time. <br
/><tt></tt> <tt></tt><p><tt>Belowis the message when i try to connect.</tt><tt></tt><p><tt>the the out put of ps in the
databaseserver.</tt><br /><tt></tt> <tt></tt><p><tt>regds</tt><br /><tt>mallah.</tt><br /><tt></tt>  <br
/><tt></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 in recovery mode</tt><br /><tt>[rmallah@system11 rmallah]$</tt><br /><tt></tt>  <br
/><tt></tt> <br /><tt></tt> <tt></tt><p><tt>[root@linux10320 data]# 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/>  

pgsql-sql by date:

Previous
From: Joe Conway
Date:
Subject: Re: SELECT in a function != SELECT ?
Next
From: Rajesh Kumar Mallah
Date:
Subject: followups : Database Server in Recovery mode!