| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2008-04-13 20:31:17 | Re: Commit fest queue |
| Previous Message | Alvaro Herrera | 2008-04-13 20:03:20 | Re: printTable API (was: Show INHERIT in \du) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-04-14 02:12:41 | Re: [HACKERS] Remove lossy-operator RECHECK flag? |
| Previous Message | Alvaro Herrera | 2008-04-13 20:03:20 | Re: printTable API (was: Show INHERIT in \du) |