Skip to content

Instantly share code, notes, and snippets.

@aaronbronow

aaronbronow/psql terminate connections

Created August 2, 2016 20:14
Show Gist options
  • Save aaronbronow/f0b0b8f2e5a8e8c81d2a4903760b6f75 to your computer and use it in GitHub Desktop.
Save aaronbronow/f0b0b8f2e5a8e8c81d2a4903760b6f75 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psql terminate connections
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND pg_stat_activity.datname = 'TARGET_DB';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment