Move Postgres production data from Heroku to Digitalocean.

November 30, 2017 2.4k views
Ruby on Rails PostgreSQL Deployment DigitalOcean Ruby Ubuntu 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.

Be the first one to answer this question.