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.