Re: postmaster hangs - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: postmaster hangs
Date
Msg-id 1113926329.20921.540.camel@state.g2switchworks.com
Whole thread Raw
In response to postmaster hangs  (Rolf Staege <Rolf.Staege@med.uni-rostock.de>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: Pallav Kalva
Date:
Subject: Re: Postgres Log rotation not working in 8.0.2
Next
From: Bobb Shields
Date:
Subject: Troubleshooting Postgres7.4