Hi Scott,
thank you for your comment
2012/7/19 Scott Marlowe
> On Thu, Jul 19, 2012 at 3:17 AM, younus wrote:
> > Hi,
> >
> > First :
> >ps -ef | grep postgres
> > and kill -9 (PID of your query)
>
> NEVER kill -9 a postgres process unless you
atname, usename, client_addr, current_query from
pg_stat_activity where current_query!='';
SELECT pg_cancel_backend (procpid);
Younus.
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/How-to-stop-a-query-tp1924086p5717297.html
Sent from the PostgreSQL - genera
Hi,
First :
ps -ef | grep postgres
and kill -9 (PID of your query)
Sec :
select procpid, datname, usename, client_addr, current_query from
pg_stat_activity where current_query!='';
and
SELECT pg_cancel_backend(procpid);
younus,
--
View this message in context:
http://
