How We Migrated from Heroku Postgres to AWS RDS

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

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

Задача

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

Результат

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

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

• 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.

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

We migrated from Heroku Postgres to AWS RDS PostgreSQL

Источник

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

Источник