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]#
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 ? |