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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq