Terminate postgres connections for aborted processes.

gistfile1.sql

SELECT pg_terminate_backend(pid)
FROM pg_stat_activity 
WHERE datname = 'DB'
  AND pid <> pg_backend_pid()
  AND state = 'idle in transaction (aborted)' 
  AND state_change < current_timestamp - INTERVAL '5' MINUTE