How to debug a locked backend ? - Mailing list pgsql-general

From Csaba Nagy
Subject How to debug a locked backend ?
Date
Msg-id 1132312380.10890.337.camel@coppola.muc.ecircle.de
Whole thread Raw
Responses Re: How to debug a locked backend ?  (Martijn van Oosterhout <kleptog@svana.org>)
Re: How to debug a locked backend ?  (Richard Huxton <dev@archonet.com>)
Re: How to debug a locked backend ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi all,

I have right now a locked backend, similar to what I had a few days ago.
It won't answer to pg_cancel_backend.
Is there a way to diagnoze what it is actually doing ?

If you answer, please do it quickly as in max 15 minutes I'll kill -9
...

Thanks,
Csaba.



pgsql-general by date:

Previous
From: "Wolfgang Keller"
Date:
Subject: Re: Sun supporting PostgreSQL
Next
From: "Aftab Alam"
Date:
Subject: trigger