Postgres Pro
Downloads
Home   >   mailing lists

how can I drop database though user connections to it (force drop) - Mailing list pgsql-admin

From Sofer, Yuval
Subject how can I drop database though user connections to it (force drop)
Date
Msg-id F8B9B12641FB6B4FAC761BDEF9D63B040F181E70@tlv-ex-01.adprod.bmc.com
Whole thread Raw
List pgsql-admin
Tree view

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@bmc.com

 

pgsql-admin by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: How to kill process "idle in transaction"
Next
From: yogesh
Date:
Subject: Abt Conversion Number to String