【PostgresSql】删除数据库报错:cannot drop the currently open database
查看数据库相关的PID然后杀掉pq: cannot drop the currently open database解决方案:SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='database-name' AND pid<>pg_backend_pid();把这个
·
查看数据库相关的PID然后杀掉
pq: cannot drop the currently open database
解决方案:
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname='database-name' AND pid<>pg_backend_pid();
把这个pid的进程干掉
然后用超级管理员执行:
DROP DATABASE 'database-name'
Postgre获取当前session的后台进程号(pid)
SELECT pg_backend_pid();
更多推荐
已为社区贡献1条内容
所有评论(0)