Search Postgresql Archives

Re: I can't cancel/terminate query.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Jul 13, 2017 at 2:45 PM, Edmundo Robles <edmundo@xxxxxxxxxxxx> wrote:
i  executed the commands   many times like  superuser but  that queries still running :(   

On Thu, Jul 13, 2017 at 11:10 AM, Melvin Davidson <melvin6925@xxxxxxxxx> wrote:


On Thu, Jul 13, 2017 at 11:57 AM, Edmundo Robles <edmundo@xxxxxxxxxxxx> wrote:
Hi!  i have  many  too long time queries,  the oldest  is  almost 16 days, so i  tried to cancel and terminate with pg_cancel_backend and pg_terminate_backend  but queries is still running.

STIME     ELAPSED ELAPSED %CPU   PID COMMAND
jun27 15-23:05:46 1379146  0.3 29660 postgres: argos_admin bdkairos 127.0.0.1(55605) SELECT                             
jun27 15-23:05:46 1379146  0.3 29659 postgres: argos_admin bdkairos 127.0.0.1(55604) SELECT                             
jun27 15-23:05:46 1379146  0.3 29658 postgres: argos_admin bdkairos 127.0.0.1(55603) SELECT                             
jun27 15-23:05:16 1379116  0.3 29909 postgres: argos_admin bdkairos 127.0.0.1(55767) SELECT                             
jun27 15-23:04:51 1379091  0.3 30097 postgres: argos_admin bdkairos 127.0.0.1(55909) SELECT                             
jun27 15-23:03:49 1379029  0.3 30661 postgres: argos_admin bdkairos 127.0.0.1(56303) SELECT        
...
What should  i do to safely close that  queries, before to use kill command in linux? 

I have Postgres 9.4  running on debian jessie.
 


--


To cancel a process with pg_terminate_backend, you need to be a superuser.

So first;

SET ROLE postgres;

Then you should be able to
SELECT pg_terminate_backend(<pid>);   Where <pid> is the pid of process you want to termnate.
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.




--



If you are running on Linux, then:

sudo su
kill <pid>

Where <pid> is the same as in pg_terminate_backend(<pid>)

--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux