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