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

Re: Cancel/Kill backend functions

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>, <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Cancel/Kill backend functions
Date: 2004-05-27 18:08:34
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE34BB46@algol.sollentuna.se (view raw or flat)
Thread:
Lists: pgsql-patches
Arrgh, when will I ever learn :-(

Attached.

//Magnus


>-----Original Message-----
>From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us] 
>Sent: den 26 maj 2004 20:50
>To: Magnus Hagander
>Cc: Neil Conway; pgsql-patches(at)postgresql(dot)org
>Subject: Re: [PATCHES] Cancel/Kill backend functions
>
>
>
>Magnus, would you please resumbit this as a context diff?
>
>---------------------------------------------------------------
>------------
>
>Magnus Hagander wrote:
>> Okay, here is an updated patch. now uses IsBackendPid(), which is 
>> closely modeled (read cut-and-pasted) from 
>> TransactionIdIsInProgress().
>> 
>> Since it's no longer a pgstat function, I moved it to "misc.c". Not 
>> 100% that's the right place either, but it seemed like the best 
>> alternative.
>> 
>> //Magnus
>> 
>> 
>> >-----Original Message-----
>> >From: Neil Conway [mailto:neilc(at)samurai(dot)com]
>> >Sent: den 22 maj 2004 10:00
>> >To: Magnus Hagander
>> >Cc: pgsql-patches(at)postgresql(dot)org
>> >Subject: Re: [PATCHES] Cancel/Kill backend functions
>> >
>> >
>> >Magnus Hagander wrote:
>> >> Per previous discussions, here are two functions to send INT and 
>> >> TERM signals to other backends.They permit only INT and TERM, and 
>> >> permits sending only to postgresql backends (as registered in 
>> >> pgstat).
>> >
>> >Why does this depend on pgstat? ISTM it would be better to use the
>> >per-backend PGPROC information, which is stored in shared memory. 
>> >Consider TransactionIdIsInProgress() for an example.
>> >
>> >-Neil
>> >
>
>Content-Description: termbackend.patch
>
>[ Attachment, skipping... ]
>
>> 
>> ---------------------------(end of 
>> broadcast)---------------------------
>> TIP 7: don't forget to increase your free space map settings
>
>-- 
>  Bruce Momjian                        |  http://candle.pha.pa.us
>  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
>  +  If your life is a hard drive,     |  13 Roberts Road
>  +  Christ can be your backup.        |  Newtown Square, 
>Pennsylvania 19073
>

Attachment: termbackend2.patch
Description: application/octet-stream (5.4 KB)

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2004-05-27 18:30:33
Subject: Re: Cancel/Kill backend functions
Previous:From: Cyril VELTERDate: 2004-05-27 17:40:04
Subject: Re : Win32 binaries test / pg_dump problem

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