Skip site navigation (1) Skip section navigation (2)

Re: postmaster hangs

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Rolf Staege <Rolf(dot)Staege(at)med(dot)uni-rostock(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: postmaster hangs
Date: 2005-04-19 15:58:49
Message-ID: 1113926329.20921.540.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: 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.

In response to

pgsql-admin by date

Next:From: Bobb ShieldsDate: 2005-04-19 18:11:47
Subject: Troubleshooting Postgres7.4
Previous:From: Pallav KalvaDate: 2005-04-19 15:35:52
Subject: Re: Postgres Log rotation not working in 8.0.2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group