Skip to content

Instantly share code, notes, and snippets.

@i-e-b

i-e-b/disconnect.sql

Created June 14, 2021 07:03
Show Gist options
  • Save i-e-b/703241ec230ad4824a4d51687163396d to your computer and use it in GitHub Desktop.
Save i-e-b/703241ec230ad4824a4d51687163396d to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql: Disconnect other users
Raw
disconnect.sql
-- Disconnect any stray connections (like from background tasks)
SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE -- don't kill my own connection!
pid <> pg_backend_pid();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment