Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 839BE475C0F for ; Fri, 10 May 2002 07:55:56 -0400 (EDT) Received: from mail-relay.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 98328475BFE for ; Fri, 10 May 2002 07:55:52 -0400 (EDT) Received: (qmail 11540 invoked from network); 10 May 2002 11:48:39 -0000 Received: from system29.trade-india-local.com (HELO server) (192.168.0.29) by ptil-236-129-del.primus-india.net with SMTP; 10 May 2002 11:48:39 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: pgsql-sql@postgresql.org Subject: pg_ctl stop does not work. Date: Fri, 10 May 2002 17:25:17 +0530 X-Mailer: KMail [version 1.4] References: <200205101048.g4AAmAK03594@saturn.janwieck.net> <200205101713.14954.mallah@trade-india.com> In-Reply-To: <200205101713.14954.mallah@trade-india.com> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200205101725.17147.mallah@trade-india.com> X-Archive-Number: 200205/93 X-Sequence-Number: 7729 Hi Folks, Please tell me how to bring down postgresql system , the postmaster is dead but some backends still seems to be running... Please Help , i do not want to loose data again !! [root@linux10320 root2]# su - postgres bash-2.03$ pg_ctl stop /usr/local/pgsql/bin/pg_ctl: kill: (5597) - No such pid waiting for postmaster to shut=20 down................................................................ failed pg_ctl: postmaster does not shut down bash-2.03$ On Friday 10 May 2002 05:13 pm, Rajesh Kumar Mallah. wrote: > Hi > my postmaster died just now, > > only a bunch of backends running > > [rmallah@server rmallah]$ psql -h 130.94.22.209 -U tradein=20 > tradein_clients psql: could not connect to server: Connection refused > Is the server running on host 130.94.22.209 and accepting > TCP/IP connections on port 5432? > [rmallah@server rmallah]$ > > output of ps > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > > [root@linux10320 root2]# ps auxwww| grep post > postgres 5598 0.0 0.0 140412 4 ? D May07 2:31 postgres: > stats buffer process > postgres 5599 1.1 0.0 142396 20 ? R May07 48:48 postgres: > stats collector process > postgres 12262 0.0 0.0 238712 4 ? D May09 0:19 postgres: > tradein tradein_clients 130.94.20.27 SELECT > postgres 13039 0.0 0.0 139812 4 ? D May09 0:00 postgres: > checkpoint subprocess > postgres 29440 0.0 0.8 140664 9256 ? S 14:35 0:01 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 6805 0.0 0.0 140196 4 ? S 16:08 0:00 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 10154 0.0 0.0 140196 4 ? S 16:38 0:00 postgres: > tradein tradein_clients 203.196.129.235 idle > postgres 10446 0.0 0.0 140164 4 ? S 16:43 0:00 postgres: > postgres tradein_clients 203.196.129.235 idle > [root@linux10320 root2]# > > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > output of top > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > 5:29pm up 3 days, 24 min, 4 users, load average: 5.68, 5.61, 5.70 > 54 processes: 52 sleeping, 2 running, 0 zombie, 0 stopped > CPU states: 5.8% user, 44.3% system, 0.0% nice, 49.8% idle > Mem: 1028484K av, 900084K used, 128400K free, 0K shrd, 2968K > buff Swap: 971004K av, 99288K used, 871716K free=20=20=20=20=20=20=20= =20=20=20=20=20=20=20=20=20=20 > 857220K cached > > PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND > 5599 postgres 17 0 2064 20 20 R 0 99.9 0.0 53:25 > postmaster 5598 postgres 9 0 1440 4 4 D 0 0.0 0.0=20= =20 > 2:31 postmaster 12262 postgres 9 0 88564 4 4 D 0 0.0 0= .0 > 0:19 postmaster 13039 postgres 9 0 656 4 4 D 0 0.0= =20 > 0.0 0:00 postmaster 29440 postgres 9 0 10512 9256 9256 S 0= =20 > 0.0 0.8 0:01 postmaster 6805 postgres 9 0 972 4 4 S = 0 > 0.0 0.0 0:00 postmaster 10154 postgres 9 0 968 4 4 S=20= =20=20=20=20=20 > 0 0.0 0.0 0:00 postmaster 10446 postgres 9 0 964 4 4 S= =20=20=20=20 > 0 0.0 0.0 0:00 postmaster > =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D