Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id E09B1475CC7 for ; Thu, 25 Apr 2002 02:48:56 -0400 (EDT) Received: (qmail 21599 invoked from network); 25 Apr 2002 06:41:48 -0000 Received: from system11.trade-india-local.com (HELO trade-india.com) (192.168.0.11) by ptil-236-129-del.primus-india.net with SMTP; 25 Apr 2002 06:41:48 -0000 Message-ID: <3CC7A7AC.F995E2BB@trade-india.com> Date: Thu, 25 Apr 2002 12:22:28 +0530 From: Rajesh Kumar Mallah X-Mailer: Mozilla 4.76 [en] (X11; U; Linux 2.4.2-2 i686) X-Accept-Language: en MIME-Version: 1.0 To: PostgResql SQL Mailing List Subject: Database Server in Recovery mode! Content-Type: multipart/alternative; boundary="------------0BB630822387430BD77D4797" X-Archive-Number: 200204/294 X-Sequence-Number: 7558 --------------0BB630822387430BD77D4797 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Friends please help. my database server has gone in recovery mode for some reasons i donot know. what is the possible steps one shud take to bring the database up to an usable state in minimum time. Below is the message when i try to connect. the the out put of ps in the database server. regds mallah. [rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein tradein_clients psql: The Data Base System is in recovery mode [rmallah@system11 rmallah]$ [root@linux10320 data]# ps auxwww | grep post postgres 1839 0.0 0.0 138992 856 ? S Apr12 2:43 /usr/bin/postmaster -D /var/lib/pgsql/data postgres 3901 6.0 1.4 141068 15248 ? D 12:05 1:29 postgres: tradein tradein_clients 130.94.20.27 COPY root 5862 0.0 0.0 1360 512 pts/3 S 12:29 0:00 grep post [root@linux10320 data]# --------------0BB630822387430BD77D4797 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Friends

please help.

my database server has gone in recovery mode for some
reasons i donot know.

what is the possible steps one shud take to bring the database
up to an usable state in minimum time.
 

Below is the message when i try to connect.

the the out put of ps in the database server.
 

regds
mallah.
 
 

[rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein  tradein_clients
psql: The Data Base System is in recovery mode
[rmallah@system11 rmallah]$
 
 
 

[root@linux10320 data]# ps auxwww | grep post
postgres  1839  0.0  0.0 138992 856 ?        S    Apr12   2:43 /usr/bin/postmaster -D /var/lib/pgsql/data
postgres  3901  6.0  1.4 141068 15248 ?      D    12:05   1:29 postgres: tradein tradein_clients 130.94.20.27 COPY
root      5862  0.0  0.0  1360  512 pts/3    S    12:29   0:00 grep post
[root@linux10320 data]#
  --------------0BB630822387430BD77D4797--