Re: Who's attached to the database?

From: Tino Schwarze <postgresql(at)tisc(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Who's attached to the database?
Date: 2008-07-04 16:41:02
Message-ID: 20080704164102.GA4933@easy2.in-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2008-07-04 22:24:32 Re: How many table scans in a delete...
Previous Message Jessica Richard 2008-07-04 16:00:06 How many table scans in a delete...