This topic describes how to migrate an RDS PostgreSQL instance across zones in the same region. The attributes, configuration, and connection addresses of the instance remain unchanged after the migration. The time required for the migration varies depending on the data volume of the instance. In typical cases, the migration takes a few hours.

Migration scenarios

Migration type Scenario
Migrate instances from one zone to another The capacity of the zone where the instances are located is full, or the performance of the instances is affected due to other reasons.
Migrate instances from one zone to multiple zones Disaster recovery across data centers is required to improve the disaster recovery capability of the instances. The primary and secondary instances are located in different zones.

Compared with single-zone instances, multi-zone instances can withstand disasters at higher levels. For example, single-zone instances can tolerate server and rack faults, whereas multi-zone instances can tolerate data center faults.

Migrate instances from multiple zones to one zone Specific features are required.

Fees

This feature is free of charge even if you migrate instances from one zone to multiple zones.

Prerequisites

  • Cross-zone migration is available only when the region where the instances are located has multiple zones. For more information about regions and zones, see Regions and zones.
  • The DB engine version and edition are as follows:
    • PostgreSQL 10 High-availability Edition (with standard SSDs)
    • PostgreSQL 9.4

Precautions

Services may be disconnected for 30 seconds during cross-zone migration, and most operations related to databases, accounts, and networks cannot be performed. Therefore, make sure that your application is configured with automatic reconnection policies, and migrate instances during off-peak hours.

Procedure

  1. Log on to the RDS console.
  2. Select the target region.Select a region
  3. Find the target instance and click the instance ID.
  4. Click Migrate Across Zones. Migrate Across Zones button
  5. In the dialog box that appears, select the destination zone, VSwitch, and migration time, and then click OK.
    Note If you want to change the maintenance window, follow these steps:
    1. Click Change.Modify button to change the maintenance window
    2. In the Configuration Information section, select a maintenance window and click Save.Select a maintenance window
    3. Return to the Instance Information page, refresh it, and perform the steps to migrate.

APIs

API Description
MigrateToOtherZone Migrates an RDS instance from one zone to another.