Re: Please make it easy to drop a database that is in use

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

SELECT pg_terminate_backend(procpid)
FROM pg_stat_activity
WHERE datname = 'dropme';

ERROR:  must be superuser to signal other server processes

You can try this approach.

http://archives.postgresql.org/pgsql-general/2012-04/msg00100.php

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/