[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

max_connections (integer)

We have a daemon (process) that monitors certain aspects of Postgres database.  When querying today using an object relational mapper (ORM) called SQLAlchemy, the following error was encountered:

sqlalchemy.exc.OperationalError: (OperationalError) FATAL:  connection limit exceeded for non-superusers

This posting on Stack Overflow indicates that the error was caused by insufficient connections available.
http://stackoverflow.com/questions/4087238/python-django-and-threading-problem

The posting below on the PostgreSQL site states that max_connections (integer) parameter defaults to 100 connections.  There are just a handful of users.

http://www.postgresql.org/docs/8.4/static/runtime-config-connection.html

Does anyone know why this would happen?
Perhaps some connections are not being closed properly?

Thanks.
Brian

Brian Wolf
Phone: 410.367.2958
Email: ..hidden..
Try out Activus Secure Payments™, our recurring payments application. 
------------------------------------------------------------------------------
The Go Parallel Website, sponsored by Intel - in partnership with Geeknet, 
is your hub for all things parallel software development, from weekly thought 
leadership blogs to news, videos, case studies, tutorials, tech docs, 
whitepapers, evaluation guides, and opinion stories. Check out the most 
recent posts - join the conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users