Whit Armstrong <armstrong.whit@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
