Migrating on-premises PostgreSQL databases to Amazon EC2

Rajesh Madiwale, Sachin Kotwal, and Suhas Basavaraj, Amazon Web Services (AWS)

March 2023 (document history)

This guide provides an overview of options, best practices, and common scenarios for migrating your on-premises PostgreSQL databases to Amazon Elastic Compute Cloud (Amazon EC2). This type of migration is called a homogeneous migration—a rehosting approach that doesn’t require you to make any changes to your operating system or database. A homogeneous migration is ideal if you want to maintain the same on-premises PostgreSQL database environment in the AWS Cloud, while maintaining full control of the database (including superuser access) and the operating system. This guide is intended for managers, product owners, database administrators, database engineers, and delivery managers who are planning a homogeneous migration of a PostgreSQL database to Amazon EC2.