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