pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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]#

view thread (4+ messages)  latest in thread

Message-ID: <3CC7A7AC.F995E2BB@trade-india.com>
Permalink:  ../3CC7A7AC.F995E2BB@trade-india.com/
Also on:    postgresql.org/message-id/3CC7A7AC.F995E2BB@trade-india.com

 · 

reply

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