rodrigosantosbr

[postgresql] kill sessions

Dec 28th, 2018
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT pg_terminate_backend(pg_stat_activity.pid)
  2. FROM pg_stat_activity
  3. WHERE pg_stat_activity.datname = 'DATABASE_NAME'
  4. AND pid <> pg_backend_pid();
Advertisement
Add Comment
Please, Sign In to add comment