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

  <br />oops forgot to post the ps auxwww | grep "post" <p><tt><font size="-1">bash-2.03$ ps auxwww| grep
post</font></tt><br/><tt><font size="-1">postgres  3901  3.4  1.3 141068 13868 ?      D    12:05   1:29 postgres:
tradeintradein_clients 130.94.20.27 COPY</font></tt><br /><tt><font size="-1">root      6476  0.0  0.0  2156  888
pts/3   S    12:39   0:00 su - postgres</font></tt><br /><tt><font size="-1">postgres  6478  0.0  0.1  2004 1168
pts/3   S    12:39   0:00 -bash</font></tt><br /><tt><font color="#000099"><font size="-1">postgres  7058  0.0  0.3
1392003780 pts/3   S    12:44   0:00 /usr/bin/postmaster -D /var/lib/pgsql/data</font></font></tt><br /><tt><font
color="#000099"><fontsize="-1">postgres  7059  0.3  1.9 140808 19688 pts/3  D    12:44   0:00 /usr/bin/postmaster -D
/var/lib/pgsql/data</font></font></tt><br/><tt><font size="-1">postgres  7396  0.0  0.0  2324  696 pts/3    R   
12:47  0:00 ps auxwww</font></tt><br /><tt><font size="-1">postgres  7397  0.0  0.0  1360  512 pts/3    S    12:47  
0:00grep post</font></tt><br /><tt><font size="-1">bash-2.03$</font></tt><p>hmmm.  two postmasters ?? <p>and perhaps
the  "<font size="-1"><tt>postgres: tradein tradein_clients 130.94.20.27 COPY"  </tt>is the guilty one</font><p>how do
iget rid of that ... <p>anyway heading for a reboot becoz this is a live server ! <br />(am i risking  data loss?? here
)<p>regds <br />mallah. <br />  <br />  <p>Rajesh Kumar Mallah wrote: <blockquote type="CITE">Hi Friends <p>please
help.<p>my database server has gone in recovery mode for some <br />reasons i donot know. <p>what is the possible steps
oneshud take to bring the database <br />up to an usable state in minimum time. <br />  <p><tt>Below is the message
wheni try to connect.</tt><p><tt>the the 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 Data Base System is in recovery mode</tt><br /><tt>[rmallah@system11
rmallah]$</tt><br/>  <br />  <br />  <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/> </blockquote>