PostgreSQL删除库报错
文章目录
前言
一、问题:
PostgreSQL删除数据库时报ERROR: (55006) database “testdb” is being accessed by other users
二、原因:
1.当前有其他连接在使用该数据库,导致无法drop库。
ERROR: (55006) database "testdb" is being accessed by other users
DETAIL: There are 5 other sessions using the database.
三、解决方法:
1.查询testdb库当前有哪些连接:
SELECT pg_stat_activity.pid
FROM pg_stat_activity
WHERE datname='testdb'
AND pid <> pg_backend_pid();
2.中断testdb库的连接:
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE datname='testdb'
AND pid <> pg_backend_pid();
3.再次删除库:
postgres=# drop database testdb;
DROP DATABASE
总结
如无法删除,重试多次。