Postgres in AWS Migration Evaluator

Yes, AWS Migration Evaluator can discover and create a business case for migrating on-premises PostgreSQL databases to AWS RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible.

Migration Evaluator is a tool designed to help customers build data-driven business cases for migrating to AWS. It can assess various on-premises environments, including databases like PostgreSQL, to provide insights and recommendations for migration.

The process typically involves the following steps:

1. Data Collection: Migration Evaluator can use its collector tool to automatically gather inventory data from your on-premises environment, including PostgreSQL databases. Alternatively, if you already have the data or prefer not to install the collector, you can import the data using a flat file.

2. Assessment: Once the data is collected, Migration Evaluator analyzes it to provide insights about your current environment.

3. Business Case Creation: Based on the collected data and analysis, Migration Evaluator generates a business case within a few business days. This business case includes recommendations for migrating your PostgreSQL databases to AWS services like Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible.

4. Optimization Recommendations: The assessment may also include recommendations for optimizing your database setup in AWS, such as suggestions for instance types or configurations that best match your current workload.

5. Cost Projections: The business case typically includes cost projections for running your PostgreSQL databases in AWS, helping you understand the potential financial implications of the migration.

It's important to note that while Migration Evaluator provides valuable insights for building a business case, the actual migration process would involve additional steps and potentially other AWS services like the AWS Database Migration Service (DMS) for the actual data transfer and schema conversion.

By leveraging Migration Evaluator, you can make more informed decisions about migrating your on-premises PostgreSQL databases to AWS, understanding both the technical feasibility and the business implications of such a move.
Sources
Seeking Advice on Utilizing Migration Evaluator for AWS Migration Business Cases | AWS re:Post
Community | Migration acclerator | S01 E23 | Lets Talk About Data Show