Drop a database being accessed by another users?

Question

I'm trying to drop a database from PgAdmin 3 and I get this error message:

ERROR: can't delete current database
SQL state: 55006

how can I force the delete/fix this error, of this database?

Answer 1

This post by Leeladharan Achar was helpful for me in working with this error.

It essentially boils down to:

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'target_db'
  AND pid <> pg_backend_pid();

DROP DATABASE 'target_db';