We decided to move from Heroku to AWS as our hosting provider in 2022 due to issues with PostgreSQL cloud offerings available at the time, including limited support for newer versions and smaller set of supported PSQL extensions. We had to overcome challenges such as handling large-scale data migration, converting data types, and minimizing downtime during the process. The entire process took about five weeks to complete, with extensive planning and testing. We learned that using partitioned tables, setting correct timeouts, and leveraging learnings from the migration are key takeaways for others attempting a similar project. A successful migration hinges on detailed planning, clear communication, extensive testing, balancing risk and downtime, and leveraging learnings.