how can I drop database though user connections to it (force drop)

From: "Sofer, Yuval" <Yuval_Sofer(at)bmc(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: how can I drop database though user connections to it (force drop)
Date: 2007-11-01 09:38:57
Message-ID: F8B9B12641FB6B4FAC761BDEF9D63B040F181E70@tlv-ex-01.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I need to drop database.

"drop database" does not always work, since user connections to the
database still exist

(I get : ERROR: database "yuval" is being accessed by other users , SQL
state: 55006)

How can I force the drop ? or is there a way to kill database
connection and then to perform the drop as usual ?

Thanks,

Yuval Sofer
BMC Software
CTM&D Business Unit

DBA Team
972-52-4286-282
yuval_sofer(at)bmc(dot)com

Browse pgsql-admin by date

  From Date Subject
Next Message yogesh 2007-11-01 10:35:35 Abt Conversion Number to String
Previous Message Achilleas Mantzios 2007-11-01 08:24:07 Re: How to kill process "idle in transaction"