解决方案也就是删除掉不用的数据库,OE会提示当前有N个Session不让Drop数据库。
对于Postgres 9.1 版本,在pgAdmin中查询以下语句:
SELECT pg_terminate_backend(pg_stat_activity.procpid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'TARGET_DB' AND procpid <> pg_backend_pid();
对于 9.2+版本:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'TARGET_DB' AND pid <> pg_backend_pid();