Failed to connect to database - can't push PostgreSQL database to heroku

Question

I created a very simple blog app with a couple of entries and all I'm trying to do is push it to heroku, but I get the following error:

$ heroku db:push [[email protected]:appname/blog.git]
Loaded Taps v0.3.24
Auto-detected local database: postgres://[email protected]/blog_development?en
coding=WIN1252
Warning: Data in the app 'afternoon-taiga-2755' will be overwritten and will not
be recoverable.

!    WARNING: Destructive Action
!    This command will affect the app: afternoon-taiga-2755
!    To proceed, type "afternoon-taiga-2755" or re-run this command with --conf
irm afternoon-taiga-2755

> afternoon-taiga-2755
Failed to connect to database:
Sequel::AdapterNotFound -> LoadError: cannot load such file -- pg

But I've got the pg gem installed and the sequel gem installed. Here is my gemfile. I've excluded a few lines because they were commented out. Has anyone ran into this problem?

source 'https://rubygems.org'

gem 'rails', '3.2.13'

# Bundle edge Rails instead:
# gem 'rails', :git => 'git://github.com/rails/rails.git'

 gem 'pg'
 gem 'activerecord-postgresql-adapter'
 gem 'sequel'


# Gems used only for assets and not required
# in production environments by default.
group :assets do
  gem 'sass-rails',   '~> 3.2.3'
  gem 'coffee-rails', '~> 3.2.1'

# See https://github.com/sstephenson/execjs#readme for more supported runtimes
# gem 'therubyracer', :platforms => :ruby

  gem 'uglifier', '>= 1.0.3'
end

gem 'jquery-rails'

Taps is not the recommended way by heroku anymore, did you try that : devcenter.heroku.com/articles/heroku-postgres-import-export — pjam
– pjam, Commented Apr 12, 2013 at 17:04
Hmm...I'll read through the tutorial and give it a try. Thanks — RubyDude1012
– RubyDude1012, Commented Apr 12, 2013 at 17:10
How does config/database.yml look like? Did you change anything in it? — Jason Kim
– Jason Kim, Commented Apr 12, 2013 at 17:43
@pjam I created a blog_development.dump file in my root directory folder of my app and I'm assuming I need to use the pgbackups:restore to upload it. Is that right...can you clear this up a little? — RubyDude1012
– RubyDude1012, Commented Apr 12, 2013 at 17:55

Community · Accepted Answer · 2017-05-23 10:25:07Z

3

I was having the same issue with db:pull. After making sure I had all the gems installed, it worked (with a hat tip to: heroku db:pull not working).

gem install pg heroku taps sequel

edited May 23, 2017 at 10:25

CommunityBot

11 silver badge

answered Jun 20, 2013 at 12:32

Ben Morris

3772 silver badges12 bronze badges

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

Collectives™ on Stack Overflow

Failed to connect to database - can't push PostgreSQL database to heroku

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related