Failed to pull db from Heroku

Question

Trying pull the database from Hekoku to local but failed.

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

Admittedly, I have no clue how should I construct the url. In the official site it was heroku db:push postgres://postgres:mypass@remotehost/mydb and in this article heroku db:pull postgres://root:@localhost/db_name was used. What the user name and password is for?

Anyway, the error message I got was:

 Sequel::DatabaseConnectionError -> TypeError: wrong argument type Sequel::Postgres::Adapter (expected Struct)

Having followed the instructions by update the taps, sequel, and pg and here is my gem list:

rest-client (1.6.7)
sinatra (1.0)
taps(0.3.24)
sequel (3.37.0, 3.20.0)
pg (0.14.0)

Can you post the full backtrace? It's hard to diagnose the cause of the problem without it. — Jeremy Evans, Jul 06 '12 at 16:10
Is your application using Activerecord, or are you just pulling this manually? — Neil Middleton, Jul 06 '12 at 16:34

score 0 · Accepted Answer · edited May 23 '17 at 12:04

0

This question is no longer relevant now as I have switched from the shared sqlite database to the 9.1 development pg database as been suggested here. Consequently, instead of using the simple db pull/push , I will use a more sophiscated pgbackup ,which was actually recommended by Heroku.

edited May 23 '17 at 12:04

Community

1
1

answered Jul 14 '12 at 13:26

pierrotlefou

39,805
37
135
175

Failed to pull db from Heroku

1 Answers1