2007/10/24, Christian Schröder <cs@xxxxxxxxx>:> 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 somegarbage. 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
