解决方法 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;

posted @ 2016-12-13 16:51  屌丝IT男  阅读(695)  评论(0编辑  收藏  举报