postgresql死锁的解决方法:
postgresql版本为9.4
一、先查询出锁死的表名

select pid,query,* from pg_stat_activity where datname='zjd_xian_dev_1'  --and waiting='t'

二、找到pid

select oid,relname from pg_class where relname='d_lz_gz';
select locktype,pid,relation,mode,granted,* from pg_locks  where relation='422852'  //oid

三、根据pid终止后台死锁项

select pg_terminate_backend('3956');   //pid

—the—end—