From: Rajesh Kumar Mallah <mallah@trade-india.com>
To: PostgResql SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Database Server in Recovery mode!
Date: Thu, 25 Apr 2002 12:22:28 +0530
Message-ID: <3CC7A7AC.F995E2BB@trade-india.com> (raw)
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]#
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com
Subject: Re: Database Server in Recovery mode!
In-Reply-To: <3CC7A7AC.F995E2BB@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox