X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 26C3553479 for ; Tue, 19 Apr 2005 11:39:13 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03056-10 for ; Tue, 19 Apr 2005 14:38:47 +0000 (GMT) Received: from apollo.med.uni-rostock.de (apollo.med.uni-rostock.de [139.30.160.50]) by svr1.postgresql.org (Postfix) with ESMTP id A88B05337F for ; Tue, 19 Apr 2005 11:38:41 -0300 (ADT) Received: from dig.med.uni-rostock.de (unknown [139.30.160.42]) by localhost.med.uni-rostock.de (Postfix) with SMTP id 3EF5A77A19 for ; Tue, 19 Apr 2005 16:40:00 +0200 (CEST) Received: from firebird.med.uni-rostock.de (firebird.med.uni-rostock.de [139.30.160.40]) by apollo.med.uni-rostock.de (Postfix) with SMTP id 01A6377A10 for ; Tue, 19 Apr 2005 16:40:00 +0200 (CEST) Received: from proxy.klinikum.uni-rostock.de by firebird.med.uni-rostock.de via smtpd (for apollo.med.uni-rostock.de [139.30.160.50]) with SMTP; 19 Apr 2005 13:46:28 UT Received: from [139.30.143.114] (dvs114.klinikum.uni-rostock.de [139.30.143.114]) by nproxy.med.uni-rostock.de (8.9.3/8.9.3/klinikum.0) with ESMTP id QAA05373 for ; Tue, 19 Apr 2005 16:19:15 +0200 (MEST) Message-ID: <426517F4.1040603@med.uni-rostock.de> Date: Tue, 19 Apr 2005 16:38:44 +0200 From: Rolf Staege User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: postmaster hangs Content-Type: text/plain; charset=ISO-8859-15; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200504/264 X-Sequence-Number: 17277 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