Back

postgres - FATAL: sorry, too many clients already

发布时间: 2019-04-25 23:31:00

参考：https://stackoverflow.com/questions/2757549/org-postgresql-util-psqlexception-fatal-sorry-too-many-clients-already

1. 修改配置文件中的

# by dashi
max_connections = 1000

2. 重启数据库

3. 验证：

postgres=# SELECT * FROM pg_stat_activity;
postgres=# SELECT COUNT(*) from pg_stat_activity;

Back