Skip to content

Instantly share code, notes, and snippets.

@detj

detj/drop_connections.sql

Created September 17, 2025 15:07
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save detj/3eb9d5931aff3b9628f1bad5ccd3515c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save detj/3eb9d5931aff3b9628f1bad5ccd3515c to your computer and use it in GitHub Desktop.
Download ZIP
Drop all Postgres connections
Raw
drop_connections.sql
-- Drop all connections except the one running this query
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'measure'
AND pid <> pg_backend_pid();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment