Disclaimer: This may be a dumb question. This is honestly way over my head... one of the pitfalls of using Heroku for too long.
I have a PostgreSQL database on Heroku. Now I'm migrating to Digital Ocean where I will be using PostgreSQL with PostGIS on Ubuntu 14.04. I would like to export my PostgreSQL database from Heroku and import it into Digital Ocean.
Is this possible? Is there any potential issues I should look out for?