title: PostgreSQL advisory lock stays after user disconnect
body: <p>I have a backend application that implements session level advisory lock. However, if the client suddenly loses the connection (e.g forcing reboot while connected) the advisory lock stays there and will not disappear. </p>
  
  <p>Is there a way to always make the lock expire after a dropped connection? </p>
  
  <p>Thanks.</p>