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?

CraigKerstiens · Accepted Answer · 2012-07-09 14:46:13Z

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 9, 2012 at 14:46

CraigKerstiens

5,9891 gold badge27 silver badges29 bronze badges

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

Comments

John Beynon · Accepted Answer · 2012-07-09 08:16:12Z

0

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.

answered Jul 9, 2012 at 8:16

John Beynon

37.5k8 gold badges92 silver badges97 bronze badges

Collectives™ on Stack Overflow

heroku db:pull to ubuntu postgresql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related