Question

Move Postgres production data from Heroku to Digitalocean.

I deployed my Ruby On Rails application to DigitalOcean on Ubuntu 16.04. I have already placed my production on Heroku and was using its free dynos for sometimes. So my Production data is there on heroku’s PostgreSql. I deployed my site code on digital ocean everything is working fine. Now Heroku rotates credentials periodically and updates applications where this database is attached. And I have exported database from Heroku which is in Binary format. Now how I supposed to place that file or data to my digital ocean’s Postgres database which I have created at the time of deploying. I followed https://gorails.com/deploy/ubuntu/16.04 this article to deploy on DigitalOcean.

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Hello,

Indeed you are correct, you have to export your database from your Heroku instance and then import it to your DigitalOcean instance.

If you are using a Managed database cluster, you could do a live migration by following the steps here:

https://docs.digitalocean.com/products/databases/postgresql/how-to/migrate

Best,

Bobby