Heroku“psql：FATAL：剩余的连接槽被保留用于非复制超级用户连接” [英] Heroku "psql: FATAL: remaining connection slots are reserved for non-replication superuser connections"

问题描述

我正在用Postgresql后端开发Heroku上的应用程序。定期地，当从CLI尝试访问数据库并从服务器上加载页面时，我会收到此错误消息：

  psql：FATAL：其余连接槽保留给非复制超级用户连接
  

可以指向正确的方向吗？

解决方案

您需要增加 max_connections 配置设置或（可能更好）使用连接合并以通过较小的连接池发送大量用户请求。

https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

I'm developing an app on Heroku with a Postgresql backend. Periodically, I get this error message when trying to access the database, both from the CLI and from loading a page on the server:

psql: FATAL: remaining connection slots are reserved for non-replication superuser connections

Anyone seen this before or can point me in the right direction?

解决方案

You either need to increase the max_connections configuration setting or (probably better) use connection pooling to route a large number of user requests through a smaller connection pool.

https://wiki.postgresql.org/wiki/Number_Of_Database_Connections

这篇关于Heroku“psql：FATAL：剩余的连接槽被保留用于非复制超级用户连接”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！