Provides distributed locking functionality via Postgres session-level advisory locks.
Acquires an exclusive session-level advisory lock, waiting if needed.
Releases an exclusive session-level advisory lock, waiting if needed.