Re: How to stop a query

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: pgsql-general(at)postgresql(dot)org
Cc: A B <gentosaker(at)gmail(dot)com>
Subject: Re: How to stop a query
Date: 2009-09-04 05:53:02
Message-ID: 200909040753.03010.guillaume@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Le vendredi 4 septembre 2009 à 07:37:20, A B a écrit :
> Hi.
> How can I abort a query that I see is listed in
>
> select * from pg_stat_activity;

You have to do:

SELECT pg_cancel_backend(pid of the postgres process);

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2009-09-04 05:53:26 Re: How to stop a query
Previous Message gabriel munteanu 2009-09-04 05:46:21 custom datatype - rgb color