: FATAL: sorry, too many clients already

时间:2025-02-09 16:57:26

1 登录数据库

2 查看当前最多连接数

show max_connections;

3 查看当前连接数;

select count(*),pg_stat_activity.usename from pg_stat_activity group by pg_stat_activity.usename;

4 修改vim  
max_connections =  1000

4 bin目录下重启数据库:

./pg_ctl -D /data/pgsql/pg_data/ stop

./pg_ctl -D /data/pgsql/pg_data/ -l /data/pgsql/log start