Bug之nested exception is org.postgresql.util.PSQLException: FATAL: sorry, too man

论坛 期权论坛 编程之家     
选择匿名的用户   2021-5-29 00:04   75   0

PostgrSQL的连接数过多,修改一下默认的连接数

https://stackoverflow.com/questions/2757549/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.
分享到 :
0 人收藏
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

积分:3875789
帖子:775174
精华:0
期权论坛 期权论坛
发布
内容

下载期权论坛手机APP