比如删除test数据库
![](https://img2020.cnblogs.com/blog/1015707/202101/1015707-20210118153505841-467851857.jpg)
登陆终端,执行
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='test' AND pid<>pg_backend_pid();
drop database test;
即可删除test数据库
![](https://img2020.cnblogs.com/blog/1015707/202101/1015707-20210118153505762-1046167179.jpg)
![](https://img2020.cnblogs.com/blog/1015707/202101/1015707-20210118153505817-679365998.jpg)
比如删除test数据库
登陆终端,执行
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='test' AND pid<>pg_backend_pid();
drop database test;
即可删除test数据库