How We Migrated from Heroku Postgres to AWS RDS

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

Команда перенесла базу данных с Heroku Postgres на AWS RDS, снизив расходы и повысив контроль над конфигурацией.

Задача

The team needed to move their production database from Heroku Postgres to AWS RDS to reduce costs and gain more control over the database environment.

Результат

The migration completed with minimal downtime and reduced monthly database costs.

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

• 1. Created a new PostgreSQL instance on AWS RDS.
• 2. Used pg_dump to export the Heroku database to a .sql file.
• 3. Transferred the dump file to an EC2 instance or directly to RDS using psql.
• 4. Restored the dump into the RDS instance with pg_restore or psql.
• 5. Updated application configuration to point to the new RDS endpoint.
• 6. Performed a data integrity check and switched traffic to the new database.

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

We created a new PostgreSQL instance on AWS RDS.

Источник

We used pg_dump to export the Heroku database to a .sql file.

Источник

We transferred the dump file to an EC2 instance or directly to RDS using psql.

Источник

We restored the dump into the RDS instance with pg_restore or psql.

Источник