Postgresql – Drop connections script
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’;– view active connections select *…