postgresql 客户端溢出
我不断收到错误：
致命：抱歉，客户太多 已经
没有遇到过这个问题，但我最近升级到了 9.03 版本，还升级到了 OS X lion 预览版 2。进程有多空闲似乎并不重要，它们永远不会死掉。我必须每半小时左右重新启动一次postgres。我通过 Rails 3 和 Navicat 使用 postgres，之前从未遇到过任何问题，并且停止两个客户端并不能解决问题。
我缺少任何想法或设置吗？不确定我的设置应该在此处显示哪些设置，但一切都应该是默认的。使用 HOMEBREW 安装 postgres。
I keep getting the error:
FATAL: sorry, too many clients
already
I never had the problem before, but I recently upgraded to version 9.03 and also OS X lion preview release 2. It doesn't seem to matter how idle the processes are, they never die. I have to restart postgres every half hour or so. I'm using postgres via Rails 3 and Navicat, never had a problem with either before now and stopping both clients does nothing to solve the problem.
Any ideas or settings I'm missing? Not sure what settings I should display here for my setup, but everything should be default. Installed postgres using HOMEBREW.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
最有可能进入 postgresql.conf 并编辑 max_connections 并发布现有值。要查看您有多少个连接以及它们正在做什么，请从 pg_stat_activity 中选择。也许是你的血脉相连？
请参阅此链接
http://www.postgresql.org/docs/9.0/interactive /runtime-config-connection.html
Most likely go into postgresql.conf and edit max_connections and post the existing value.To see how many connections you have an what they are doing select from pg_stat_activity. Maybe your bleeding connections?
See this link
http://www.postgresql.org/docs/9.0/interactive/runtime-config-connection.html