pgsql问题排查

本文主要是介绍pgsql问题排查，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

1.项目启动时报错

FATAL: remaining connection slots are reserved for non-replication superuser connections

--查看当前的连接
select datname,pid,application_name,state from pg_stat_activity;

--查看当前剩余的连接
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;

--关闭无用的连接
SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE state='idle';

这篇关于pgsql问题排查的文章就介绍到这儿，希望我们推荐的文章对大家有所帮助，也希望大家多多支持为之网！