Question : postgresql stop all connections
Answered by : abobakr
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid <> pg_backend_pid() AND datname = 'db_name';
Source : | Last Update : Mon, 16 May 22
Question : how to stop all connections to a psql 12 database?
Answered by : ricardo-hincapie
# Works for psql 12
select pg_terminate_backend(pid) from pg_stat_activity where datname='<db_name>';
Source : https://dba.stackexchange.com/a/16427/224108 | Last Update : Wed, 18 Aug 21
Question : postgres kill all connections
Answered by : lonely-curly-boi
SELECT pg_terminate_backend(pid)
FROM pg_stat_activity
WHERE pid <> pg_backend_pid() AND datname = 'database_name';
Source : https://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection | Last Update : Mon, 27 Jul 20