How We Migrated from Heroku Postgres to AWS RDS

Описание и применение

Перенос базы данных с Heroku Postgres на AWS RDS позволил улучшить масштабируемость и снизить расходы.

Задача

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

Результат

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

Рабочий процесс

• 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

Доказательства

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

Источник