Skip to content

Instantly share code, notes, and snippets.

@superchell

superchell/Remove advisory locks

Last active August 31, 2020 09:25
Show Gist options
  • Save superchell/c53c8babf4d1bc937f3bf1c1ac555f8f to your computer and use it in GitHub Desktop.
Save superchell/c53c8babf4d1bc937f3bf1c1ac555f8f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Remove advisory locks
SELECT pg_advisory_unlock_all();
или
SELECT pid, locktype, mode FROM pg_locks WHERE locktype = 'advisory';
SELECT pg_terminate_backend(<PID>);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment