pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rolf Staege <Rolf.Staege@med.uni-rostock.de>
To: pgsql-admin@postgresql.org
Subject: postmaster hangs
Date: Tue, 19 Apr 2005 16:38:44 +0200
Message-ID: <426517F4.1040603@med.uni-rostock.de> (raw)

hi,
i'm using postgres version 7.4.1 and it run very stable until, may be,  
4 weeks ago.
now the postmaster hangs sometimes for a while (actually since 2 hours) 
and doesn't accept connections but comes back anytime. there is no 
possibility to stop the postmaster. even a kill -9 (it's only the 
developement system) doesn't work. i have to reboot the system to get 
the database running again.
actually ps brings:
postgres  2148     1  0  Mar 11  ?         0:28 
/usr/local/pgsql/bin/postmaster -i -d 2

top shows the postmaster process as follows:
 ?     2148 postgres 154 20   210M   244K run      0:28  0.02  0.02 
postmaster

the output of netstat is (grep for 5432):
tcp        0      0  192.168.143.116.5432    192.168.143.116.61145    
ESTABLISHED
tcp        0      0  192.168.143.116.61145   192.168.143.116.5432     
ESTABLISHED
tcp        0      0  *.5432                 *.*                     LISTEN
tcp        0      0  192.168.143.116.5432    192.168.143.114.2550     
ESTABLISHED
        45d91540 stream     38      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        45d916c0 stream     39      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        40ed2680 stream     38      0                0         
43191e80                0                0 /tmp/.s.PGSQL.5432
        40ed2b00 stream     38      0                0         
4458a400                0                0 /tmp/.s.PGSQL.5432
        440c3b80 stream     37      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        440c3d00 stream     37      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        449e5100 stream     37      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        43c65240 stream     37      0                0         
4458a280                0                0 /tmp/.s.PGSQL.5432
        43a15200 stream      0      0         43b48c40                
0                0                0 /tmp/.s.PGSQL.5432
        437db7c0 stream     37      0                0                
0                0                0 /tmp/.s.PGSQL.5432
        437dbc40 stream     37      0                0                
0                0                0 /tmp/.s.PGSQL.5432

the server is a pa-risc system with a HP-UX 11.11, 64Bit
does anybody has an idea, what could be the reason for it?
thanks
rolf



view thread (7+ messages)  latest in thread

Message-ID: <426517F4.1040603@med.uni-rostock.de>
Permalink:  ../426517F4.1040603@med.uni-rostock.de/
Also on:    postgresql.org/message-id/426517F4.1040603@med.uni-rostock.de

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Rolf.Staege@med.uni-rostock.de
  Subject: Re: postmaster hangs
  In-Reply-To: <426517F4.1040603@med.uni-rostock.de>
  References: <426517F4.1040603@med.uni-rostock.de>

* 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