View and kill postgresql connections to database

This article is tagged with: View and kill postgresql connections to database and mysql

view and kill postgresql connections to database

/* view connections */
SELECT * FROM pg_stat_activity;
/*-— Kill connections*/
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 = 'clinical_data';
/* kill a specific connection */
select pg_terminate_backend(13337)

This article is tagged with: View and kill postgresql connections to database and mysql