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

Re: [HACKERS] Terminating a backend

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Terminating a backend
Date: 2008-04-13 20:04:51
Message-ID: 20080413200451.GC21979@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian wrote:

> I have a idea --- to have pg_terminate_backend() set a PGPROC boolean
> and then send a query cancel signal to the backend --- the backend can
> then check the boolean and exit if required.  I will work on a new
> version of this patch tomorrow/Monday.

That's fine, even if it fails on 0.1% of the cases, but you can't use
SIGTERM to implement that because it already has a different meaning.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-hackers by date

Next:From: Josh BerkusDate: 2008-04-13 20:31:17
Subject: Re: Commit fest queue
Previous:From: Alvaro HerreraDate: 2008-04-13 20:03:20
Subject: Re: printTable API (was: Show INHERIT in \du)

pgsql-patches by date

Next:From: Tom LaneDate: 2008-04-14 02:12:41
Subject: Re: [HACKERS] Remove lossy-operator RECHECK flag?
Previous:From: Alvaro HerreraDate: 2008-04-13 20:03:20
Subject: Re: printTable API (was: Show INHERIT in \du)

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