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.