jeffjohnson9046 · June 18, 2018 18:10 · yarikefremov · Jan 31, 2025
diff --git a/kill-all-connections-to-db.sql b/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();
	-- 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();