Re: Who's attached to the database? - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: Who's attached to the database?
Date
Msg-id 20080704164102.GA4933@easy2.in-chemnitz.de
Whole thread Raw
In response to Re: Who's attached to the database?  (Lennin Caro <lennin.caro@yahoo.com>)
List pgsql-admin
On Fri, Jul 04, 2008 at 06:50:43AM -0700, Lennin Caro wrote:
> try this
>
> select pg_cancel_backend(<processid_db>);
>
> if the command not work kill the process in os
>
> kill -9 proccessid_os

*NO*! Never kill -9 a postgres backend!!! This is like a headshot, no
chance to clean up. You will make your whole pg server shut down!

A simple kill should suffice.

Tino.

--
"What we nourish flourishes." - "Was wir nähren erblüht."

www.craniosacralzentrum.de
www.forteego.de

pgsql-admin by date:

Previous
From: Jessica Richard
Date:
Subject: How many table scans in a delete...
Next
From: "Scott Marlowe"
Date:
Subject: Re: How many table scans in a delete...