Database Server in Recovery mode!

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: PostgResql SQL Mailing List <pgsql-sql(at)postgresql(dot)org>
Subject: Database Server in Recovery mode!
Date: 2002-04-25 06:52:28
Message-ID: 3CC7A7AC.F995E2BB@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)system11 rmallah]$ psql -h 130.94.22.209 -Utradein
tradein_clients
psql: The Data Base System is in recovery mode
[rmallah(at)system11 rmallah]$

[root(at)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(at)linux10320 data]#

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2002-04-25 07:06:28 followups : Database Server in Recovery mode!
Previous Message Joe Conway 2002-04-25 06:13:37 Re: SELECT in a function != SELECT ?