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 0000453208 for ; Tue, 19 Apr 2005 12:58:57 -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 40344-05 for ; Tue, 19 Apr 2005 15:58:53 +0000 (GMT) Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id CDA8C52A85 for ; Tue, 19 Apr 2005 12:58:51 -0300 (ADT) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 19 Apr 2005 10:58:49 -0500 Subject: Re: postmaster hangs From: Scott Marlowe To: Rolf Staege Cc: pgsql-admin@postgresql.org In-Reply-To: <426517F4.1040603@med.uni-rostock.de> References: <426517F4.1040603@med.uni-rostock.de> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1113926329.20921.540.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 19 Apr 2005 10:58:49 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/270 X-Sequence-Number: 17283 On Tue, 2005-04-19 at 09:38, Rolf Staege wrote: > 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. In addition to what Tom said (i.e. look at hardware problems) I'd also recommend updating the latest update of your versions of pgsql, 7.4.7.