java链接pg数据库remaining connection slots are reserved for non-replication superuser connections问题

　　　最近遇到链接pg数据库报错：remaining connection slots are reserved for non-replication superuser connections。百度说，是由于设置的最大连接数满了，解决办法都是改最大连接数，或者杀掉状态为idle的链接。设计到的sql查询如下：

　　查询当前所有空闲链接：

　　select datname,pid,application_name,state from pg_stat_activity where state='idle' ;

　　查询当前所有连接数：
　　select count(1) from pg_stat_activity;

　　查询最大连接数：
　　show max_connections;

　　select current_setting('max_connections');

　　终止空闲链接

　　select pg_terminate_backend(pid) from pg_stat_activity where pid<>pg_backend_pid() and state='idle';

　　查看为超级用户保留的连接数:

　　show superuser_reserved_connections;

　　查看每个用户的而连接数：
　　select usename, count(*) from pg_stat_activity group by usename order by count(*) desc;

　　查看数据库剩余连接数：

　　select max_conn-now_conn as resi_conn from (select setting::int8 as max_conn,(select count(*) from pg_stat_activity) as now_conn from pg_settings where name = 'max_connections') t;

　　修改最大连接数配置：

　　转载：https://blog.csdn.net/myhes/article/details/120868668?ops_request_misc=&request_id=&biz_id=102&utm_term=remaining%20connection%20slots%20are&utm_medium=distribute.pc_search_result.none-task-blog-2~all~sobaiduweb~default-2-120868668.nonecase&spm=1018.2226.3001.4187和https://blog.csdn.net/u013332981/article/details/110792449。

巴特西

java链接pg数据库remaining connection slots are reserved for non-replication superuser connections问题

最新文章

热门文章