"postgresql gem is not loaded" error deploying a Ruby on Rails application on Heroku

Question

I am trying to use postgresql with Ruby on Rails on Heroku but got an error

Specified 'postgresql' for database adapter, but the gem is not loaded. Add `gem 'pg'` to your Gemfile (and ensure its version is at the minimum required by ActiveRecord). (Gem::LoadError)

Please help me to solve this issue.

add pg gem and run bundle install ...then setup database using heroku run rake db:migrate — Milind
– Milind, Commented Aug 1, 2015 at 9:23
What were the reasons for Heroku choosing PostgreSQL over MySQL? Please refer this link quora.com/… — Akshay Borade
– Akshay Borade, Commented Aug 3, 2015 at 13:31

cameck · Accepted Answer · 2018-04-22 17:56:51Z

25

This worked for me

gem 'pg', '~> 0.20'

Thanks to Piers C

Got this answer from

Heroku and Rails: Gem Load Error with Postgres, however it is Specified in GEMFILE

edited Apr 22, 2018 at 17:56

cameck

2,09822 silver badges34 bronze badges

answered Jun 29, 2017 at 5:38

user2576537

8019 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2576537 Over a year ago

simply adding gem 'pg' to the gemfile didn't work for me. Seems to be a version issue.

vidur punj Over a year ago

Thank you so much, also commit gemfile.lock, after doing bundle update

Simone Carletti · Accepted Answer · 2015-10-08 19:37:51Z

7

In your Gemfile

group :production do
  gem 'pg'
end

Then run bundle install and try to deploy on Heroku.

If you want to use PostgreSQL on all environments and not only in production (recommended) add the gem outside the :production group and remove other database adapters such as sqlite.

As a side note, you may also want to add the rails_12factor gem as suggested by Heroku.

edited Oct 8, 2015 at 19:37

Simone Carletti

177k50 gold badges371 silver badges370 bronze badges

answered Aug 1, 2015 at 8:30

Akshay Borade

2,47215 silver badges26 bronze badges

Comments

vidur punj · Accepted Answer · 2018-02-02 05:54:55Z

7

Add pg in gemfile

 gem 'pg', '~> 0.20'

then bundle update & commit Gemfile & Gemfile.lock to heroku.
simple include like gem 'pg' will not work.

edited Feb 2, 2018 at 5:54

answered Jan 22, 2018 at 16:37

vidur punj

6,0195 gold badges53 silver badges73 bronze badges

Comments

Ramin Mammadzada · Accepted Answer · 2020-08-26 13:21:25Z

0

I added the following version into my gemfile, and it is solved.

gem "pg", "~> 0.18"

answered Aug 26, 2020 at 13:21

Ramin Mammadzada

3674 silver badges11 bronze badges

Collectives™ on Stack Overflow

"postgresql gem is not loaded" error deploying a Ruby on Rails application on Heroku

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related