PostgreSQL 锁表解决方案

根据表名查询pid列表

0
1
2
3
4
select locks.pid
from pg_locks locks
inner join pg_class class
on locks.relation = class.oid
where class.relname = 'table_name';

使用终止函数终止pid

0
select pg_terminate_backend(pid);
Licensed under CC BY-NC-SA 4.0
最后更新于 May 24 2023 21:16 CST
Powered by HugoStack