Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Heroku and Postgresql and Rails - too many connections error

Tags:

postgresql

ruby-on-rails

heroku

I'm getting the following error with Ruby on Rails, Heroku and Postgresql:

PG::Error (FATAL:  too many connections for role "********"

I've restarted the server several times to no avail. Any ideas?

like image 908
sabes Avatar asked Aug 17 '12 02:08

sabes

People also ask

What is Heroku connection limit?

Heroku provides managed Postgres databases. Different tiered databases have different connection limits. The Hobby Tier databases are limited to 20 connections. Standard and higher tier databases have higher limits.

Can Postgres handle multiple connections?

PostgreSQL Connection Limits At provision, Databases for PostgreSQL sets the maximum number of connections to your PostgreSQL database to 115. 15 connections are reserved for the superuser to maintain the state and integrity of your database, and 100 connections are available for you and your applications.

1 Answers

Paying Heroku more money isn't always the answer.

I had this problem temporarily when I was running up against the dev-level database's row limit. Deleting rows using the console until I was below the limit solved the issue.

Another potential way you can run into this is if you're using unicorn. The number of connections used is the number of dynos times the number of unicorn workers per dyno. Heroku explains it all here, along with a way to configure it in config/unicorn.rb.

Also, seeing the number of connections being used can be useful. Just run heroku pg:info.

like image 88
Jonathan Tran Avatar answered Oct 30 '22 00:10

Jonathan Tran
Sign in to Comment

Related questions

Modifying the params hash in Rails
calling a controller action with argument from rack middleware
How to use RVM to install Ruby 1.9.3 when Xcode 4.3.2 is installed and gcc is missing?
Why does Rails validate unchanged attributes?
Rails nested attributes - how to add category attribute to new product?
skip_before_filter when api_key is present
How to use postgres extensions on Heroku? And how to handle their migrations?
Rails 3.2 and yui compressor
cucumber working fine without spork, but spork giving me "uninitialized constant Cucumber::Rails"
Efficiently retrieving ice_cube schedules for a given time period
How to populate a table with data vertically?
How to have multiple constraints in Rails routes.rb?
Does Rails controller actions define transactional bondaries implicitly?
Bad interpreter: No such file or directory
Getting Fonts to work in Rails 3.1?
Rails ActiveRecord Model Linked List
Why can I use RMagick from irb but not rails console?
Client side data encryption/decryption for rails application
Mixing radio buttons and text_field
Upgrading Rails app from 3.2.6 to 3.2.8

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!