解决方法 test: database removal failed: ERROR: database "test" is being accessed by other users

select * from pg_stat_activity where datname='test';

找出哪个进程用了这个数据库,然后删除这个进程(pid)

kill -9 47182

然后再删除数据库

drop database test;

原文地址:https://www.cnblogs.com/hltswd/p/6170598.html