PG 断开所有连接

postgresql - How to drop all connections to a specific database without stopping the server? - Database Administrators Stack Exchange

断开所有 DB_NAME 数据库的连接：

select pg_terminate_backend(pid) from pg_stat_activity where datname='DB_NAME';