1、查询锁死表的pid select pid from pg_locks where relation in (select oid from pg_class where relname=‘表名’); 2、解锁数据表 select pg_terminate_backend(‘上一步查询到的pid’);
解决postgresql数据库数据表锁死问题1、查询锁死表的pidselect pid from pg_locks where relation in (select oid from pg_class where relname=‘表名’);2、解锁数据表select pg_terminate_backend(‘上一步查询到的pid’);