I used pg_advisory_lock as a one-worker gate and got a lock that dies with the connection, no-ops behind a transaction pooler, and has no fencing token. Here's what to use instead.

#postgres #advisorylocks #distributed