Postgres Pro
Downloads
Home   >   mailing lists

Is there a way to kill a connection from the pg_stat_activitly list? - Mailing list pgsql-admin

From Jessica Richard
Subject Is there a way to kill a connection from the pg_stat_activitly list?
Date
Msg-id 23085.65196.qm@web56403.mail.re3.yahoo.com
Whole thread Raw
Responses Re: Is there a way to kill a connection from the pg_stat_activitly list?  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: Is there a way to kill a connection from the pg_stat_activitly list?  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
List pgsql-admin
Tree view
When you see a hanging Postgres connection (or a job running so long and you don't want to continue any more) from

select * from pg_stat_activity

and you want to disconnect it,

how do you do it?

thanks,
Jessica

Check out the hottest 2008 models today at Yahoo! Autos.

pgsql-admin by date:

Previous
From: Alexander Kuprijanov
Date:
Subject: Re: How to update from 8.1 to 8.2 ?
Next
From: Kenneth Marshall
Date:
Subject: Re: How to update from 8.1 to 8.2 ?