当postgresql执行删除操作时,报Error
删除语句
DROP DATABASE cmdb;
报错:
ERROR: database "cmdb" is being accessed by other users
DETAIL: There are 18 other sessions using the database.
这是需要释放掉会话才能删除,需要执行一段会话的查询SQL
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE datname='数据库的名字' AND pid<>pg_backend_pid();
再次执行删除库的SQL语句就能成功的删除了