Heroku - how to pull data from database to the local database?

Question

I am trying to fetch database on Heroku and the data from there to save into my local database.

When I try

heroku db:pull

and confirm the name of the app, I get:

 !    db:push and db:pull have been removed and replaced with pg:push and pg:pull.
 !    For more information, please see:
 !      devcenter.heroku.com/articles/heroku-postgresql#pg-push-and-pg-pull

Ok, so:

pg:pull

returns:

-bash: pg:pull: command not found

heroku pg:pull

returns

 !    `pg:pull` is not a heroku command.
 !    Perhaps you meant `db:pull` or `pg:psql`.
 !    See `heroku help` for a list of available commands.

Thus, how to properly pull the data?

Have you find a solution to that?

arniotaki
– arniotaki

2015-09-23 06:23:34 +00:00
Commented Sep 23, 2015 at 6:23 — arniotaki
– arniotaki, Commented Sep 23, 2015 at 6:23

Aaron Brager · Accepted Answer · 2016-07-12 22:14:12Z

7

Per the Heroku Postgres help, you have to specify the database you are pulling from and to for pg:pull to work.

$ heroku pg:pull HEROKU_POSTGRESQL_MAGENTA mylocaldb --app sushi

This command will create a new local database named mylocaldb and then pull data from the database at DATABASE_URL from the app sushi. To prevent accidental data overwrites and loss, the local database must not exist. You will be prompted to drop an already existing local database before proceeding.

This also assumes you have Postgres on your local machine.

heroku pg:info will give you all available information, such as name, on your Heroku databases.

edited Jul 12, 2016 at 22:14

Aaron Brager

66.4k21 gold badges169 silver badges295 bronze badges

answered Mar 14, 2014 at 14:10

ChrisBarthol

4,9792 gold badges24 silver badges24 bronze badges

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

1 Comment

sudo Over a year ago

mylocaldb can be a Postgres URL like postgres://postgres:p0stgres@localhost/heroku, which will create a database called heroku

magnum · Accepted Answer · 2014-03-20 01:05:34Z

0

in your project's dir, after installing taps gem, you can try using

taps server `heroku config:get DATABASE_URL` db db

to start a taps server, and then

taps push mysql://[usernme]:[password]@[host]/[database] http://db:db@localhost:500

to sync local db to heroku through taps

answered Mar 20, 2014 at 1:05

magnum

1,0901 gold badge8 silver badges7 bronze badges

Collectives™ on Stack Overflow

Heroku - how to pull data from database to the local database?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related