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
原创
2021-10-27 15:54:23 ·
512 阅读 ·
0 评论