查询并杀掉Postgresql相应的进程

select c.pid,a.relname,c.* from
pg_class a,
pg_locks b,
pg_stat_activity c
where b.relation = a.oid
and b.pid = c.pid
and a.relname='table_name';--表名

select pg_terminate_backend(上面pid);
————————————————

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

原文链接：https://blog.csdn.net/qq_35388136/article/details/132832628