Re: Killing Long running query or user session - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: Killing Long running query or user session
Date
Msg-id 4118AB80.5030209@bigfoot.com
Whole thread Raw
List pgsql-admin
David Ecker wrote:

> How can I kill/stop a long running query or a complete user session using an
> superuser account?
>
> Thx
> David Ecker

At my knowledge you have to kill SIGTERM the backedn that is managing the
connection. Do as super user "select * from pg_stat_activity", look at
the procpid that have to be killed and kill it.



Regards
Gaetano Mendola




pgsql-admin by date:

Previous
From: jseymour@linxnet.com (Jim Seymour)
Date:
Subject: Re: psql won't stayed connected
Next
From: "Rodrigo Botana"
Date:
Subject: Replication