FAQ - AWS Prescriptive Guidance

FAQ

Does this guide cover all the use cases for migrating an on-premises PostgreSQL database to Amazon EC2?

This guide covers the most common use cases, but it doesn’t cover every possible use case. Commercial tools, for example, are beyond the scope of this guide.

Are the migration options covered in this guide applicable to all PostgreSQL versions?

It depends on the use case. For example, if you’re planning to use physical replication for your PostgreSQL migration, then you must have PostgreSQL 9.2 or later versions. In contrast, if you’re planning to use logical replication for your migration, then you must have PostgreSQL 10 or later versions.