Assessing your database environment before migration - AWS Prescriptive Guidance

Assessing your database environment before migration

Before starting the migration, we recommend that you assess your on-premises database environment. An assessment can help you choose a migration approach and strategy that best aligns with your technical requirements and business needs.

We recommend that you complete the following assessment tasks:

  • Analyze and categorize the criticality of your PostgreSQL database.

  • Check the database size and project its future growth for at least the next five years.

  • Generate a pgBadger report to analyze the database workload.

  • Understand the peak usage of I/O, CPU, concurrent connections, and other relevant metrics so that you can choose the appropriate EC2 instance type for your workload.

  • Generate PostgreSQL diagnostic support scripts, and then analyze the results to gain insights and anticipate the challenges of using AWS Database Migration Service (AWS DMS) for the migration.

  • Tune the postgresql.conf file to find out the optimal values for achieving the best performance of your instance sizes (that is, for disk IOPS, memory, and CPU).

  • Update the pg_hba.conf file so that both your application servers and bastion hosts connect to the same virtual private cloud (VPC).