RROR: database “xxx“ is being accessed by other users DETAIL: There are 2 other sessions using

psotgresql navicate删除数据库提示如下信息，解决办法：

先删除链接信息

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

然后再执行删除即可！