On Thu, Aug 5, 2010 at 9:40 AM, Szymon Guz <mabew...@gmail.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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general