Whit Armstrong <armstrong.w...@gmail.com> writes:
> I had a few queries that were fired from pgAdmin, but failed to stop
> running after I killed the GUI.
> I tried to stop the queries by killing the pid (of the process running
> the query, not the pid of the server) from the linux command line, and
> much to my surprise, the whole database went down and then recovered
> (using the data in pg_xlog I assume).
I suppose you used "kill -9"? Don't do that.
> So, now that I've learned this lesson, what is the proper way to kill
> a query, and can it be done from psql or are there special postgres
> tools to do this.
kill -INT is a safe query-cancel method.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
