Tuesday, 16 August 2016

Removing TABLE Locks in POSTGRES


1) Find Blocked Tables with the below query and get the PID.

select t.relname,l.locktype,page,virtualtransaction,pid,mode,granted from pg_locks l, pg_stat_all_tables t where l.relation=t.relid order by relation asc;

2) Pass the PID in the below query to Remove the LOCK
SELECT pg_terminate_backend(6052);

get it

 http://hinekv1.ddns.net:8008/get.php?username=Varga_Florentina1tv&password=j5MgWBs18t&type=m3u_plus&output=mpegts http://www.lo...