删除尚有连接的PG数据库

执行如下语句

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

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

posted @ 2018-05-27 18:10  岳麓丹枫  阅读(181)  评论(0编辑  收藏  举报