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.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.