On Thu, Aug 5, 2010 at 9:40 AM, Szymon Guz <mabewlun(at)gmail(dot)com> wrote:
> killing it with -9 crashed the whole PostgreSQL server, don't do that.
> Instead just login to the database and run the function
> pg_cancel_backend() http://www.postgresql.org/docs/8.4/static/functions-admin.html,
> much more safe way.
Or, assuming you're still in the shell typing those commands, just hit
ctrl-c to cancel the current query.