On Thu, Jul 25, 2013 at 7:32 PM, kris <kkvilek...@gmail.com> wrote: > > We are running a replicated (multiple machines behind ngnix) Turbogears > 2.1.5 App With SA 0.7.8 and postgres 8.4 > > After a lot of recent usage the system ground to halt and we are receiving > (OperationalError) FATAL: sorry, too many clients already > > while trying to any DBSession.query. > > Any ideas what could cause this?
As the message says, you have too many open connections. When you have multiple machines, you must either provision your postgres to be able to handle a full connection pool (max_overflow preferrably, pool_size at least) for each nginx worker for each machine, or have SQLA connect to a pgbouncer that will do the shared pooling for you. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.