Adam Witney <awitney@sgul.ac.uk> writes:
> 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?
In theory that should always work. What PG version is this? Can you
attach to the stuck backend with gdb and get a stack trace?
regards, tom lane