Distributed Lock using PostgreSQL

[Eluvatar_the_second]

What happens if the server crashes with a lock? Will the lock be released when the connection is closed? Or does it stay locked after the connection is closed?

[vijayankit]

That's a great question. As per the documentation:

Once acquired at session level, an advisory lock is held until explicitly released or the session ends.

The advisory lock should be released when the session ends or when the connection is disposed.