pg.ddx.io pgsql-sql@postgresql.org mailing list archive help / color / mirror / Atom feed From: Rajesh Kumar Mallah. <mallah@trade-india.com>
To: Jan Wieck <janwieck@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: postmaster dead now !!
Date: Fri, 10 May 2002 17:19:30 +0530
Message-ID: <200205101719.30759.mallah@trade-india.com> (raw )
In-Reply-To: <200205101713.14954.mallah@trade-india.com >
References: <200205101048.g4AAmAK03594@saturn.janwieck.net >
<200205101713.14954.mallah@trade-india.com >
Also wanted to highlight that the
"stats collector process" (PID: 5599)
is the one which is taking up 99% CPU in my top
output ,
postgres 5599 1.3 0.0 142396 20 ? S May07 57:13 postgres: stats
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
> 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
> ============
>
> [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]#
>
> =============
> output of top
> =============
> 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
> 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
> 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
> 0.0 0:00 postmaster 29440 postgres 9 0 10512 9256 9256 S 0
> 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
> 0 0.0 0.0 0:00 postmaster 10446 postgres 9 0 964 4 4 S
> 0 0.0 0.0 0:00 postmaster
> ==========================================================================
view thread (2+ messages)
Message-ID: <200205101719.30759.mallah@trade-india.com>
Permalink: ../200205101719.30759.mallah@trade-india.com/
Also on: postgresql.org/message-id/200205101719.30759.mallah@trade-india.com
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mallah@trade-india.com, janwieck@yahoo.com
Subject: Re: postmaster dead now !!
In-Reply-To: <200205101719.30759.mallah@trade-india.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox