How to cancel a query if SIGINT does not work?

From: Adam Witney <awitney(at)sgul(dot)ac(dot)uk>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How to cancel a query if SIGINT does not work?
Date: 2005-08-19 15:17:37
Message-ID: BF2BB6A1.4B1E6%awitney@sgul.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I have a query that appears to have hung somehow. I have tried sending a
SIGINT but this does not cancel it... What's the next step without taking
down the whole server?

Thanks

Adam

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2005-08-19 15:22:04 Re: total db lockup
Previous Message Stephan Szabo 2005-08-19 15:12:08 Re: [GENERAL] Cascades Failing