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

it2023-06-02  72

1 登录数据库

2 查看当前最多连接数

show max_connections;

3 查看当前连接数;

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

4 修改vim postgresql.conf  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

最新回复(0)