PostgreSQL问题解决--连接数过多

本文主要是介绍PostgreSQL问题解决--连接数过多，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

---

错误描述

用pgAdmin连接数据库时，提示

Connection could not be allocated because: FATAL: sorry, too many clients already

---

通用解决步骤

来自stackoverflow–org.postgresql.util.PSQLException: FATAL: sorry, too many clients already，

1. First find your postgresql.conf file
2. If you don’t know where it is, query the database with the sql: SHOW config_file;
3. Mine is in: /var/lib/pgsql/data/postgresql.conf
4. Login as root and edit that file.
5. Search for the string: “max_connections”.
6. You’ll see a line that says max_connections=100.
7. Set that number bigger, check the limit for your postgresql version.
8. Restart the postgresql database for the changes to take effect.

这篇关于PostgreSQL问题解决--连接数过多的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---