pgsql删除数据库提示有线程占用无法删除

参考：
https://blog.csdn.net/liuchunming033/article/details/46878473

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