org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

– 查看已连接数量
select count(*),pg_stat_activity.usename from pg_stat_activity group by pg_stat_activity.usename;

– 查看已连接详细信息
select * from pg_stat_activity;

– 关闭所有连接
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE datname=‘postgres’ AND pid<>pg_backend_pid();