SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'db' -- ! replace db with the target database name AND pid <> pg_backend_pid();
Tuesday, February 12, 2019
Drop all active connections to PostgreSQL server
Labels:
PostgreSQL
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.