Skip site navigation (1) Skip section navigation (2)

Re: Pet Peeves?

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pet Peeves?
Date: 2009-01-29 18:55:13
Message-ID: 200901291055.13908@hal.medialogik.com (view raw or flat)
Thread:
Lists: pgsql-general
On Thursday 29 January 2009, Terry Fielder <terry(at)ashtonwoodshomes(dot)com> 
wrote:
> and that ties to:
> 2) If I try to kill 1 postgres pid (e.g. to abort a bad query), the
> whole backend shuts down and rolls back.
> Can we get a way to look at and then kill a specific bad query?

select pg_cancel_backend(pid). Or kill pid from the shell, it only kills off 
one backend on 8.x anyway.


-- 
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE 

In response to

pgsql-general by date

Next:From: Mark StylesDate: 2009-01-29 19:07:51
Subject: Re: Changing owner of pg_toast tables
Previous:From: Tommy GildsethDate: 2009-01-29 18:53:07
Subject: Re: Text search segmentation fault

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group