Kill all user sessions to a single database in PostgreSQL
This is something I found myself doing a few times and it's not obvious.
Start a super user shell and run this, replace
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = '<my-database>'
AND pid <> pg_backend_pid();
Last update:
October 2, 2021