{"id":7844,"date":"2015-10-31T12:18:07","date_gmt":"2015-10-31T12:18:07","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2015\/10\/31\/heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections-open-source-projects-koush-superuser\/"},"modified":"2015-10-31T12:18:07","modified_gmt":"2015-10-31T12:18:07","slug":"heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections-open-source-projects-koush-superuser","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2015\/10\/31\/heroku-psql-fatal-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections-open-source-projects-koush-superuser\/","title":{"rendered":"Heroku &#8220;psql: FATAL: remaining connection slots are reserved for non-replication superuser connections&#8221;-open source projects koush\/Superuser"},"content":{"rendered":"<p><img decoding=\"async\" src=\"http:\/\/www.gravatar.com\/avatar\/39ccc051ad2e74367f6d07b378f94eca?s=128&amp;d=identicon&amp;r=PG\" \/> <strong>markshiz<\/strong><\/p>\n<p>I actually tried to implement connection pooling on the django end using:<\/p>\n<p>https:\/\/github.com\/gmcguire\/django-db-pool<\/p>\n<p>but I still received this error, despite lowering the number of connections available to below the standard development DB quota of 20 open connections.<\/p>\n<p>There is an article here about how to move your postgresql database to the free\/cheap tier of Amazon EC2. This would allow you to set <code>max_connections<\/code> higher. This will also allow you to pool connections at the database level using PGBouncer.<\/p>\n<p>http:\/\/www.askthepony.com\/blog\/2011\/07\/getting-django-on-heroku-prancing-8-times-faster\/<\/p>\n<p><strong>UPDATE:<\/strong><\/p>\n<p>Heroku responded to my open ticket and stated that my database was improperly load balanced in their network. They said that improvements to their system should prevent similar problems in the future. Nonetheless, support manually relocated my database and performance is noticeably improved.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>markshiz I actually tried to implement connection pooling on the django end using: https:\/\/github.com\/gmcguire\/django-db-pool but I still received this error, despite lowering the number of connections available to below the standard development DB quota of 20 open connections. There is an article here about how to move your postgresql database to the free\/cheap tier of [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-7844","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=7844"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/7844\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=7844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=7844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=7844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}