Postgresql – Drop connections script

August 21, 2014 · by · in His

Select another database in pgadmin and execute this script to drop all connected users.

Script

-- view active connections
SELECT * FROM pg_stat_activity WHERE datname='DBNAME';
-- drop active connections
SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE datname='DBNAME';
Tags: , , ,