Skip to content

Instantly share code, notes, and snippets.

@pramoth

pramoth/kill-all-connections-to-db.sql

Forked from jeffjohnson9046/kill-all-connections-to-db.sql
Created February 27, 2026 15:20
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save pramoth/09da456a351eddb99e8870fa98af4aa2 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save pramoth/09da456a351eddb99e8870fa98af4aa2 to your computer and use it in GitHub Desktop.
Download ZIP
How to kill all connections to a Postgres database
Raw
kill-all-connections-to-db.sql
-- Accepted answer from here: https://stackoverflow.com/questions/5408156/how-to-drop-a-postgresql-database-if-there-are-active-connections-to-it
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '[your database name goes here]'
AND pid <> pg_backend_pid();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment