>>We'd probably need a tool like "pgsignal" or something that 
>>would send signals to the backends. Since you can't use the 
>>kill commandline tool (that one only supports what would be 
>>called kill -9 on unix)
>
>When the user says "net stop postmaster", an entry point in
>postmaster will be called by the Service Control Manager. Then
>postmaster will have to send the signals to the other processes
>asking them to stop and presumably wait for them to stop before
>terminating itself.

Absolutely, but there are other signals to send, no? Or you might want
to send a signal directly to a backend (to cancel for example), as you
can do on Unix.

//Magnus

Tue, 16 Dec 2003 20:30:28 +0100
"Magnus Hagander" <mha@sollentuna.net>
Re: [HACKERS] [PATCHES] fork/exec patch
Magnus Hagander wrote:

>
>Absolutely, but there are other signals to send, no? Or you might want
>to send a signal directly to a backend (to cancel for example), as you
>can do on Unix.
>
>  
>

In normal operation the only thing that should be signalling a backend 
is the postmaster.

cheers

andrew


Tue, 16 Dec 2003 15:20:53 -0500
Andrew Dunstan <andrew@dunslane.net>
Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch
Andrew Dunstan <andrew@dunslane.net> writes:
> In normal operation the only thing that should be signalling a
> backend is the postmaster.

Oh? What about LISTEN/NOTIFY?

-Neil


Tue, 16 Dec 2003 17:37:31 -0500
Neil Conway <neilc@samurai.com>
Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch
Neil Conway kirjutas K, 17.12.2003 kell 00:37:
> Andrew Dunstan <andrew@dunslane.net> writes:
> > In normal operation the only thing that should be signalling a
> > backend is the postmaster.
> 
> Oh? What about LISTEN/NOTIFY?

IIRC cancelling queries is done by making a connection to a new backend
and then this backend signalls the one needing to have its query
cancelled. Or is the cancelling done by postmaster without starting a
new backend ?

--------------
Hannu


Wed, 17 Dec 2003 01:08:25 +0200
Hannu Krosing <hannu@tm.ee>
Re: [pgsql-hackers-win32] [PATCHES] fork/exec patch