On Tue, Nov 30, 2010 at 10:12:47AM +0000, Florian Weimer wrote: > * hubert depesz lubaczewski: > > > Now, the question is: why did it hang? Is there anything we can do to > > make it *not* hang? > > It might be some general system overload issue. Try running "echo w > > /proc/sysrq-trigger" as root the next time it happens. This will dump > kernel backtraces to dmesg, which might hint to what's going on with > the system.
will check the idea, but the thing is that aside from postgresql - everything else on the server is working fine - ssh/top/*stat. and other postgreses seem to be locked too. Best regards, depesz -- Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/ jid/gtalk: dep...@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
