Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide - eviltoast
Transitioning from Heroku PostgreSQL to AWS EC2: Step-by-Step Guide - Stormatics
stormatics.tech
The blog describes all the steps required to safely migrate your Heroku PostgreSQL database to self managed PostgreSQL on AWS EC2 instance using logshipping method.