Skip to content

Instantly share code, notes, and snippets.

@baringji

baringji/pg.terminate.md

Created May 14, 2014 01:13
Show Gist options
  • Save baringji/7479d1d5d3d3a049d398 to your computer and use it in GitHub Desktop.
Save baringji/7479d1d5d3d3a049d398 to your computer and use it in GitHub Desktop.
Download ZIP
Disconnect database connections in PostgreSQL 9.2+.
Raw
pg.terminate.md

select pg_terminate_backend(pid) from pg_stat_activity where datname = [database name];

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment