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.
原文链接:https://www.f2er.com/postgresql/194308.html

猜你在找的Postgre SQL相关文章