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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxx

 


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux