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.