How We Migrated from Heroku Postgres to AWS RDS

Description and use

Wootric migrated its database from Heroku Postgres to AWS RDS PostgreSQL, achieving better scalability and cost control.

Problem

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

Outcome

The migration completed with minimal downtime, improved performance, and better cost control.

Workflow

• 1. Assessed current Heroku Postgres usage and identified required RDS instance size.
• 2. Created an AWS RDS PostgreSQL instance with matching configuration.
• 3. Used pg_dump to export data from Heroku Postgres.
• 4. Restored dump into the new RDS instance via pg_restore.
• 5. Updated application configuration to point to the RDS endpoint.
• 6. Performed validation tests to ensure data integrity and application functionality.
• 7. Decommissioned the old Heroku Postgres instance after successful migration.

Evidence

We migrated from Heroku Postgres to AWS RDS PostgreSQL

Source

We used pg_dump to export data from Heroku Postgres and pg_restore to import into RDS

Source