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

问题描述

我正在 Heroku 上开发一个带有 Postgresql 后端的应用程序.我在尝试从 CLI 和在服务器上加载页面时尝试访问数据库时会定期收到此错误消息:

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 please help point me in the right direction?

推荐答案

您要么需要增加 max_connections 配置设置或(可能更好)使用连接池通过较小的连接池路由大量用户请求.

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:致命:剩余的连接槽是为非复制超级用户连接保留的"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！