Re: Killing Long running query or user session

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: David Ecker <david(at)familie-ecker(dot)net>
Subject: Re: Killing Long running query or user session
Date: 2004-08-10 11:03:28
Message-ID: 4118AB80.5030209@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Ecker 2004-08-10 12:47:38 Re: Killing Long running query or user session
Previous Message Jim Seymour 2004-08-10 11:01:32 Re: psql won't stayed connected