Re: [GENERAL] (Never?) Kill Postmaster?

From: Pavel Stehule <pavel.stehule(at)gmail.com>
Date: Wed Oct 24 2007 - 03:23:32 EDT

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
>

---------------------------(end of broadcast)---------------------------

TIP 2: Don't 'kill -9' the postmaster Received on Wed Oct 24 03:27:51 2007