Heroku db: not working

Question

heroku db:pull postgresql://root:@localhost/db_name 

After this command, this message will be displayed.

/usr/lib/ruby/gems/1.8/gems/rest-client-1.6.1/lib/restclient/abstract_response.rb:50: warning: arguments (brackets) in a future version Loaded taps v0.3.13 Warning: data in the database "postgresql: // root: @ localhost / db_name" will be overwritten and will not be restored. Are you sure you want to continue? (Y / N)? Y Failed to connect to the database: Sequel :: AdapterNotFound → LoadError: there is no such file to load - sequel / adapters / postgresql

How to use db: pull

Answer 1

First you need to fix the connection string: use postgres instead of postgresql .

You will need to install the pg db adapter to use the Continue postgresql adapter :

 gem install pg 

You can also make sure that your taps, sequels and jewels to the hero are updated:

 gem install heroku taps sequel 

Then try heroku db:pull again. If that doesn't work, send a comment or hop to #heroku on Freenode and we can try to help.

Answer 2

Your connection string is incorrect. Try:

 heroku db:pull postgres://root:@localhost/db_name 

Answer 3

It started to work fine as soon as I updated the "pg" pearl from version "0.11.0" to "0.12.2".