How We Migrated from Heroku Postgres to AWS RDS

Description and use

Migrating from Heroku Postgres to AWS RDS improved scalability and reduced costs.

Problem

Heroku Postgres was limiting scalability and cost control for Wootric’s growing database needs.

Outcome

Successful migration with minimal downtime, improved performance, and reduced monthly database costs.

Workflow

• 1. Assessed RDS PostgreSQL compatibility and selected instance class
• 2. Created RDS instance and configured security groups
• 3. Used pg_dump to export data from Heroku Postgres
• 4. Restored dump into RDS using pg_restore
• 5. Updated application configuration to point to RDS endpoint
• 6. Performed data integrity checks and performance testing
• 7. Decommissioned Heroku Postgres instance

Evidence

We used pg_dump to export the database and pg_restore to import it into RDS

Source