heroku db:pull to ubuntu postgresql

Question

I want to migrate my application from Heroku to my own ubuntu server. What is the correct syntax to do this using taps/heroku db:pull?

score 1 · Answer 1 · answered Jul 09 '12 at 14:46

1

If you are moving data between a local and cloud database both of which are Postgres you should follow the instructions on Heroku's Devcenter:

https://devcenter.heroku.com/articles/migrating-data-between-plans

answered Jul 09 '12 at 14:46

CraigKerstiens

5,906
1
25
28

score 0 · Answer 2 · answered Jul 09 '12 at 08:16

You would simply do heroku db:pull to pull the database from Heroku to your local db which you would then backup and restore to your own server. If it's a large database you might want to look into Heroku pgbackups as an alternative as it will provide you with a downloadable backup.

Note: If you want to migrate between databases, ie postgres => mysql then you would have to use the db:pull approach.

heroku db:pull to ubuntu postgresql

2 Answers2