nav-img
Advanced

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

Table 1 RDS for PostgreSQL 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.

  • On-premises PostgreSQL databases
  • PostgreSQL databases on ECSs

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.