How We Migrated from Heroku Postgres to AWS RDS

Description and use

Wootric successfully migrated its PostgreSQL database from Heroku to AWS RDS, gaining greater control over database configuration, scaling, and performance while reducing costs compared to the Heroku-managed setup.

Problem

Wootric needed to migrate its PostgreSQL database from Heroku to AWS RDS, moving away from Heroku's managed Postgres service to a more scalable and cost-controlled infrastructure on AWS.

Outcome

Wootric successfully migrated its PostgreSQL database from Heroku to AWS RDS, achieving greater control over database infrastructure, improved scalability options, and reduced costs compared to the previous Heroku-managed setup.

Workflow

• Provisioned an AWS RDS PostgreSQL instance matching the existing database configuration
• Dropped the Heroku-managed database and attached the new RDS instance to the application
• Updated application connection strings to point to the new AWS RDS endpoint
• Verified data integrity and application functionality after the migration

Evidence

How We Migrated from Heroku Postgres to AWS RDS

Source

Wootric needed to migrate its PostgreSQL database from Heroku to AWS RDS

Source

The application was hosted on Heroku with a PostgreSQL database provisioned through the Heroku platform

Source