Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 6A17B474E6D for ; Thu, 25 Apr 2002 03:02:54 -0400 (EDT) Received: (qmail 21618 invoked from network); 25 Apr 2002 06:55: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:55:48 -0000 Message-ID: <3CC7AAF4.552563B1@trade-india.com> Date: Thu, 25 Apr 2002 12:36: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: followups : Database Server in Recovery mode! References: <3CC7A7AC.F995E2BB@trade-india.com> Content-Type: multipart/alternative; boundary="------------C44C90DC3EDA7A024960E0DC" X-Archive-Number: 200204/295 X-Sequence-Number: 7559 --------------C44C90DC3EDA7A024960E0DC Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi i tried to stop it later and following is what is happening regds mallah. bash-2.03$ pg_ctl -D /var/lib/pgsql/data stop waiting for postmaster to shut down................................................... ............. failed pg_ctl: postmaster does not shut down bash-2.03$ then i did: bash-2.03$ pg_ctl -D /var/lib/pgsql/data stop -m immediate waiting for postmaster to shut down....done postmaster successfully shut down bash-2.03$ pg_ctl -D /var/lib/pgsql/data start postmaster successfully started bash-2.03$ DEBUG: database system was interrupted at 2002-04-25 12:10:43 IST DEBUG: CheckPoint record at (91, 2768917524) DEBUG: Redo record at (91, 2768306852); Undo record at (91, 2718752328); Shutdown FALSE DEBUG: NextTransactionId: 10070150; NextOid: 86521966 DEBUG: database system was not properly shut down; automatic recovery in progress... DEBUG: redo starts at (91, 2768306852) DEBUG: open(logfile 91 seg 166) failed: No such file or directory DEBUG: redo done at (91, 2785015440) The Data Base System is starting up bash-2.03$ on connesting from a cleint: [rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein tradein_clients psql: The Data Base System is starting up [rmallah@system11 rmallah]$ Rajesh Kumar Mallah wrote: > 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]# > --------------C44C90DC3EDA7A024960E0DC Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi i tried to stop it later
and following is what is happening

regds
mallah.
 

bash-2.03$ pg_ctl -D /var/lib/pgsql/data stop
waiting for postmaster to shut down...................................................
............. failed
pg_ctl: postmaster does not shut down
bash-2.03$

then i did:

bash-2.03$ pg_ctl -D /var/lib/pgsql/data stop  -m immediate
waiting for postmaster to shut down....done
postmaster successfully shut down
bash-2.03$ pg_ctl -D /var/lib/pgsql/data start
postmaster successfully started
bash-2.03$ DEBUG:  database system was interrupted at 2002-04-25 12:10:43 IST
DEBUG:  CheckPoint record at (91, 2768917524)
DEBUG:  Redo record at (91, 2768306852); Undo record at (91, 2718752328); Shutdown FALSE
DEBUG:  NextTransactionId: 10070150; NextOid: 86521966
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (91, 2768306852)
DEBUG:  open(logfile 91 seg 166) failed: No such file or directory
DEBUG:  redo done at (91, 2785015440)
The Data Base System is starting up

bash-2.03$
 

on connesting from a cleint:

[rmallah@system11 rmallah]$ psql -h 130.94.22.209 -Utradein  tradein_clients
psql: The Data Base System is starting up
[rmallah@system11 rmallah]$
 
 

Rajesh Kumar Mallah wrote:

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

--------------C44C90DC3EDA7A024960E0DC--