Move Postgres production data from Heroku to Digitalocean.

Posted November 30, 2017 4.9k views
Ruby on RailsDigitalOceanPostgreSQLRubyDeploymentUbuntu 16.04

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 this article to deploy on DigitalOcean.

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!