From mallah@trade-india.com Thu Apr 25 06:48:56 2002 Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id E09B1475CC7 for ; Thu, 25 Apr 2002 02:48:56 -0400 (EDT) Received: (qmail 21599 invoked from network); 25 Apr 2002 06:41: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:41:48 -0000 Message-ID: <3CC7A7AC.F995E2BB@trade-india.com> Date: Thu, 25 Apr 2002 12:22: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: Database Server in Recovery mode! Content-Type: multipart/alternative; boundary="------------0BB630822387430BD77D4797" X-Archive-Number: 200204/294 X-Sequence-Number: 7558 --------------0BB630822387430BD77D4797 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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]# --------------0BB630822387430BD77D4797 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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]#
  --------------0BB630822387430BD77D4797-- From mallah@trade-india.com Thu Apr 25 07:06:38 2002 Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 8E0CC47597D for ; Thu, 25 Apr 2002 03:06:38 -0400 (EDT) Received: (qmail 21622 invoked from network); 25 Apr 2002 06:59:32 -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:59:32 -0000 Message-ID: <3CC7ABD4.A104986F@trade-india.com> Date: Thu, 25 Apr 2002 12:40:12 +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: Re: Database Server in Recovery mode! References: <3CC7A7AC.F995E2BB@trade-india.com> Content-Type: multipart/alternative; boundary="------------A640BBD63EA5066104B601B5" X-Archive-Number: 200204/296 X-Sequence-Number: 7560 --------------A640BBD63EA5066104B601B5 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit oops forgot to post the ps auxwww | grep "post" bash-2.03$ ps auxwww| grep post postgres 3901 3.4 1.3 141068 13868 ? D 12:05 1:29 postgres: tradein tradein_clients 130.94.20.27 COPY root 6476 0.0 0.0 2156 888 pts/3 S 12:39 0:00 su - postgres postgres 6478 0.0 0.1 2004 1168 pts/3 S 12:39 0:00 -bash postgres 7058 0.0 0.3 139200 3780 pts/3 S 12:44 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data postgres 7059 0.3 1.9 140808 19688 pts/3 D 12:44 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data postgres 7396 0.0 0.0 2324 696 pts/3 R 12:47 0:00 ps auxwww postgres 7397 0.0 0.0 1360 512 pts/3 S 12:47 0:00 grep post bash-2.03$ hmmm. two postmasters ?? and perhaps the "postgres: tradein tradein_clients 130.94.20.27 COPY" is the guilty one how do i get rid of that ... anyway heading for a reboot becoz this is a live server ! (am i risking data loss?? here ) regds mallah. 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]# > --------------A640BBD63EA5066104B601B5 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit  
oops forgot to post the ps auxwww | grep "post"

bash-2.03$ ps auxwww| grep post
postgres  3901  3.4  1.3 141068 13868 ?      D    12:05   1:29 postgres: tradein tradein_clients 130.94.20.27 COPY
root      6476  0.0  0.0  2156  888 pts/3    S    12:39   0:00 su - postgres
postgres  6478  0.0  0.1  2004 1168 pts/3    S    12:39   0:00 -bash
postgres  7058  0.0  0.3 139200 3780 pts/3   S    12:44   0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
postgres  7059  0.3  1.9 140808 19688 pts/3  D    12:44   0:00 /usr/bin/postmaster -D /var/lib/pgsql/data
postgres  7396  0.0  0.0  2324  696 pts/3    R    12:47   0:00 ps auxwww
postgres  7397  0.0  0.0  1360  512 pts/3    S    12:47   0:00 grep post
bash-2.03$

hmmm.  two postmasters ??

and perhaps the   "postgres: tradein tradein_clients 130.94.20.27 COPY"  is the guilty one

how do i get rid of that ...

anyway heading for a reboot becoz this is a live server !
(am i risking  data loss?? here )

regds
mallah.
 
 

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

--------------A640BBD63EA5066104B601B5-- From sszabo@megazone23.bigpanda.com Thu Apr 25 14:37:51 2002 Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 42727476149 for ; Thu, 25 Apr 2002 10:37:51 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id D07F3D60E; Thu, 25 Apr 2002 07:37:51 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id C42005C01; Thu, 25 Apr 2002 07:37:51 -0700 (PDT) Date: Thu, 25 Apr 2002 07:37:51 -0700 (PDT) From: Stephan Szabo To: Rajesh Kumar Mallah Cc: PostgResql SQL Mailing List Subject: Re: Database Server in Recovery mode! In-Reply-To: <3CC7ABD4.A104986F@trade-india.com> Message-ID: <20020425073615.M63157-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200204/305 X-Sequence-Number: 7569 On Thu, 25 Apr 2002, Rajesh Kumar Mallah wrote: > oops forgot to post the ps auxwww | grep "post" > > bash-2.03$ ps auxwww| grep post > postgres 3901 3.4 1.3 141068 13868 ? D 12:05 1:29 postgres: > tradein tradein_clients 130.94.20.27 COPY > root 6476 0.0 0.0 2156 888 pts/3 S 12:39 0:00 su - > postgres > postgres 6478 0.0 0.1 2004 1168 pts/3 S 12:39 0:00 -bash > postgres 7058 0.0 0.3 139200 3780 pts/3 S 12:44 0:00 > /usr/bin/postmaster -D /var/lib/pgsql/data > postgres 7059 0.3 1.9 140808 19688 pts/3 D 12:44 0:00 > /usr/bin/postmaster -D /var/lib/pgsql/data > postgres 7396 0.0 0.0 2324 696 pts/3 R 12:47 0:00 ps auxwww > > postgres 7397 0.0 0.0 1360 512 pts/3 S 12:47 0:00 grep post > > bash-2.03$ > > hmmm. two postmasters ?? > > and perhaps the "postgres: tradein tradein_clients 130.94.20.27 COPY" > is the guilty one > > how do i get rid of that ... I believe you want kill -INT 3901 to get rid of the backend. From mallah@trade-india.com Fri Apr 26 05:40:23 2002 Received: from mail-relay.trade-india.com (unknown [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 0527747589A for ; Fri, 26 Apr 2002 01:40:23 -0400 (EDT) Received: (qmail 5198 invoked from network); 26 Apr 2002 05:32:58 -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; 26 Apr 2002 05:32:58 -0000 Message-ID: <3CC8E914.713ADA51@trade-india.com> Date: Fri, 26 Apr 2002 11:13:49 +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: Stephan Szabo Cc: PostgResql SQL Mailing List Subject: Re: Database Server in Recovery mode! References: <20020425073615.M63157-100000@megazone23.bigpanda.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200204/317 X-Sequence-Number: 7581 Hmm.. was it this simple! thanks what does -INT signal do btw ?? I will try it next time when ( god forbids my database server crashes again ) mallah. Stephan Szabo wrote: > On Thu, 25 Apr 2002, Rajesh Kumar Mallah wrote: > > > oops forgot to post the ps auxwww | grep "post" > > > > bash-2.03$ ps auxwww| grep post > > postgres 3901 3.4 1.3 141068 13868 ? D 12:05 1:29 postgres: > > tradein tradein_clients 130.94.20.27 COPY > > root 6476 0.0 0.0 2156 888 pts/3 S 12:39 0:00 su - > > postgres > > postgres 6478 0.0 0.1 2004 1168 pts/3 S 12:39 0:00 -bash > > postgres 7058 0.0 0.3 139200 3780 pts/3 S 12:44 0:00 > > /usr/bin/postmaster -D /var/lib/pgsql/data > > postgres 7059 0.3 1.9 140808 19688 pts/3 D 12:44 0:00 > > /usr/bin/postmaster -D /var/lib/pgsql/data > > postgres 7396 0.0 0.0 2324 696 pts/3 R 12:47 0:00 ps auxwww > > > > postgres 7397 0.0 0.0 1360 512 pts/3 S 12:47 0:00 grep post > > > > bash-2.03$ > > > > hmmm. two postmasters ?? > > > > and perhaps the "postgres: tradein tradein_clients 130.94.20.27 COPY" > > is the guilty one > > > > how do i get rid of that ... > > I believe you want > kill -INT 3901 > to get rid of the backend. > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster