xxxxxxxxxx
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE datname = 'your_database_name';
xxxxxxxxxx
# Works for psql 12
select pg_terminate_backend(pid) from pg_stat_activity where datname='<db_name>';
xxxxxxxxxx
SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE
-- don't kill my own connection!
pid <> pg_backend_pid()
-- don't kill the connections to other databases
AND datname = 'database_name'
;
xxxxxxxxxx
SELECT
pg_terminate_backend(pid)
FROM
pg_stat_activity
WHERE
pid <> pg_backend_pid()
AND datname = 'database_name';