赞
踩
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
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。