How We Migrated from Heroku Postgres to AWS RDS

Description and use

Successfully migrated the Heroku PostgreSQL database to AWS RDS, achieving improved performance and cost control.

Problem

Wootric needed to migrate their Heroku PostgreSQL database to AWS RDS for better scalability, cost control, and reliability.

Outcome

Successfully migrated the Heroku PostgreSQL database to AWS RDS, achieving improved performance and cost control.

Workflow

• Export the Heroku PostgreSQL database using the heroku pg:dump command
• Create an AWS RDS PostgreSQL instance
• Import the exported database dump into the new RDS instance
• Update application configuration to point to the new RDS endpoint
• Verify data integrity and application functionality

Evidence

Export the Heroku PostgreSQL database using the heroku pg:dump command

Source

Create an AWS RDS PostgreSQL instance

Source

Import the exported database dump into the new RDS instance

Source

Update application configuration to point to the new RDS endpoint

Source

Verify data integrity and application functionality

Source