Migration Solution Overview
You can migrate data from self-managed PostgreSQL databases, or PostgreSQL databases built on other clouds to RDS for PostgreSQL, or from one RDS for PostgreSQL instance to another RDS for PostgreSQL instance.
DRS provides real-time synchronization. Real-time synchronization refers to the real-time flow of workload data from sources to destinations through a synchronization instance while consistency of data is ensured. It is different from migration. Migration means moving entire data of a database to another. Synchronization refers to the continuous flow of data between different applications.
Migration Solutions
Source Database | Data Size | One-Time or Continuous Migration | Application Downtime | Solution | Document |
---|---|---|---|---|---|
RDS for PostgreSQL | Small | One-time | Some time | Use pg_dump to copy data from the source to the destination RDS for PostgreSQL instance. | |
RDS for PostgreSQL | Any | One-time or continuous | Minimal | Use DRS to synchronize data from the source to the destination RDS for PostgreSQL instance. | |
| Any | One-time or continuous | Minimal | Use DRS to synchronize data from self-managed PostgreSQL databases to RDS for PostgreSQL. | |
PostgreSQL databases on other clouds | Any | One-time or continuous | Minimal | Use DRS to synchronize data from PostgreSQL databases on other clouds to RDS for PostgreSQL. |
- Migration Solutions