[PostgresSql实战]删除数据库：cannot drop the currently open database

删除数据库报错：

pq: cannot drop the currently open database

解决方案：

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

把这个pid的进程干掉

然后用超级管理员执行：

DROP DATABASE 'database-name'