Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 19E14475C26 for ; Fri, 10 May 2002 07:50:11 -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 DDC10475C0F for ; Fri, 10 May 2002 07:50:05 -0400 (EDT) Received: (qmail 11534 invoked from network); 10 May 2002 11:42:52 -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:42:52 -0000 Content-Type: text/plain; charset="iso-8859-1" From: "Rajesh Kumar Mallah." Organization: Infocom Network Limited. To: Jan Wieck Subject: Re: postmaster dead now !! Date: Fri, 10 May 2002 17:19:30 +0530 X-Mailer: KMail [version 1.4] Cc: pgsql-sql@postgresql.org 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: <200205101719.30759.mallah@trade-india.com> X-Archive-Number: 200205/92 X-Sequence-Number: 7728 Also wanted to highlight that the=20 "stats collector process" (PID: 5599) is the one which is taking up 99% CPU in my top=20 output , postgres 5599 1.3 0.0 142396 20 ? S May07 57:13 postgres: st= ats=20 collector process 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