This pattern outlines steps for migrating a PostgreSQL database (version 9.5 and later) from Amazon Elastic Compute Cloud (Amazon EC2) to Amazon Relational Database Service (Amazon RDS) for PostgreSQL by using the PostgreSQL pglogical extension. Amazon RDS now supports the pglogical extension for PostgreSQL version 10.
Prerequisites
Choose the right type of Amazon RDS instance. For more information, see Amazon RDS Instance Types.
Make sure that the source and target versions of PostgreSQL are the same.
Install and integrate the pglogical extension with PostgreSQL on Amazon EC2.
Product versions
PostgreSQL version 10 and later on Amazon RDS, with the features supported on Amazon RDS (see PostgreSQL on Amazon RDS in the AWS documentation). This pattern was tested by migrating PostgreSQL 9.5 to PostgreSQL version 10 on Amazon RDS, but it also applies to later versions of PostgreSQL on Amazon RDS.
