On Thursday 29 January 2009, Terry Fielder <terry(at)ashtonwoodshomes(dot)com>
> 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 Styles||Date: 2009-01-29 19:07:51|
|Subject: Re: Changing owner of pg_toast tables|
|Previous:||From: Tommy Gildseth||Date: 2009-01-29 18:53:07|
|Subject: Re: Text search segmentation fault|