Re: how to cancel a query ?

Andreas Schmitz <a.schmitz@cityweb.de> writes:
> ist there any way to cancel a user query as dba ?

Send a SIGINT to the backend process running that query, eg

    kill -INT <pid>

This has the same effect as a user-requested cancel (eg ^C in psql).

            regards, tom lane