Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group