2007/10/24, Christian Schröder <cs@deriva.de>:
> Ow Mun Heng wrote:
> > look for the query's procpid and then issue a select
> > pg_cancel_backend('the_id')
> >
>
> Does it do any harm if I kill (either with signal 9 or signal 15) the
> single backend process (and not the postmaster)?
>
shared memory can be broken, and probably somewhere can stay some
garbage. It's depend on query.
Pavel
> Regards,
> Christian
>
> --
> Deriva GmbH Tel.: +49 551 489500-42
> Financial IT and Consulting Fax: +49 551 489500-91
> Hans-Böckler-Straße 2 http://www.deriva.de
> D-37079 Göttingen
>
> Deriva CA Certificate: http://www.deriva.de/deriva-ca.cer
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>