Restore data of an ApsaraDB RDS for PostgreSQL instance - ApsaraDB RDS

If backup files are created for an ApsaraDB RDS for PostgreSQL instance, you can restore the backup data to a new RDS instance. This method is suitable for the analysis of historical data and the restoration of data on which unintended operations are performed.

Feature description

ApsaraDB RDS for PostgreSQL allows you to restore data from a backup set or to a point in time. The entire restoration process consists of the following steps:

Restore the backup data to a new RDS instance.
Log on to the new RDS instance and verify the data on the new RDS instance.
Migrate the data from the new RDS instance to the original RDS instance.

Note

For more information about data restoration methods, see Overview of data restoration methods.

Prerequisites

The original RDS instance meets the following requirements:

The original RDS instance is in the Running state.
No ongoing migration tasks exist.
At least one backup set is complete. This requirement must be met if you want to restore data from backup sets.
The log backup feature is enabled for the original RDS instance. This requirement must be met if you want to restore data to a specific point in time. For more information, see Configure automatic backups.
Note
RDS instances that run RDS Basic Edition do not support the log backup feature. You cannot restore data of the RDS instance to a point in time.

Usage notes

The new RDS instance and the original RDS instance must have the same backup and parameter settings.
The data and account information of the new RDS instance must be the same as the data and account information that is indicated by the specified data or log backup file of the original RDS instance.

Billing rules

You are charged for the new RDS instance. You can view the price of the new RDS instance when you create the instance.

Note

If you want to temporarily use an RDS instance, you can create a pay-as-you-go RDS instance. After data is restored to the new RDS instance, you can migrate the data to the original RDS instance and then release the new RDS instance. For more information, see Migrate data between ApsaraDB RDS instances and Release or unsubscribe from an ApsaraDB RDS for PostgreSQL instance.
You are immediately charged for the new RDS instance after the instance is created.

Restore data to a new RDS instance

Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Backup and Restoration.
In the upper-left corner of the page that appears, click Restore Database.

Configure the following parameters.

Parameter	Description
Billing Method	Subscription: A subscription RDS instance is an instance for which you pay an upfront fee. For long-term usage, the subscription billing method is more cost-effective than the pay-as-you-go billing method. You are charged lower prices for longer subscription periods. Pay-As-You-Go: A pay-as-you-go RDS instance is billed per hour based on your actual resource usage. We recommend that you select the pay-as-you-go billing method for short-term use. If you no longer require a pay-as-you-go RDS instance, you can release it to reduce costs.
Restore Method	By Time: allows you to restore data to a point in time within the specified log retention period. For more information about how to view or modify the log backup retention period, see Back up an ApsaraDB RDS for PostgreSQL instance. By Backup Set: allows you to restore the data from a backup set. Note The By Time option is available only if the log backup feature is enabled.
Edition	Basic Edition: The database system consists of only one RDS instance. Computing is separated from storage to increase cost-effectiveness. High-availability Edition: The database system adopts the classic high-availability architecture that consists of one primary RDS instance and one secondary RDS instance. Note The available RDS editions vary based on the region and database engine version that you select. For more information, see Overview.
Deployment Method	You can select the Single-zone Deployment or Multi-zone Development method. A zone is an independent physical location within a region. The Zone of Primary Node parameter specifies the zone in which the primary RDS instance resides. The Zone of Secondary Node parameter specifies the zone in which the secondary RDS instance resides. Single-zone Deployment: If you select this deployment method, the values of the Zone of Primary Node and Zone of Secondary Node parameters are the same. Multi-zone Development: If you select this deployment method, the values of the Zone of Primary Node and Zone of Secondary Node parameters are different. We recommend that you select this deployment method to perform zone-disaster recovery. You must configure the Zone of Primary Node and Zone of Secondary Node parameters. Note After the new RDS instance is created, you can view information about the new RDS instance and its secondary RDS instance on the Service Availability page. If you select RDS Basic Edition, the database system consists of only one primary RDS instance and supports only the single-zone deployment method.
Instance Type	General-purpose (Entry-level): allows you to select a general-purpose instance type. A general-purpose RDS instance exclusively occupies the allocated memory and I/O resources, but shares CPU and storage resources with the other general-purpose RDS instances that are deployed on the same server. Dedicated (Enterprise-level): allows you to select a dedicated instance type or a dedicated host instance type. A dedicated RDS instance exclusively occupies the CPU, memory, storage, and I/O resources that are allocated. Dedicated host instance types provide the highest specifications in the dedicated instance family. A dedicated host RDS instance occupies all CPU, memory, storage, and I/O resources on the physical host where the RDS instance is deployed. Note Each instance type supports a specific number of CPU cores, memory capacity, maximum number of connections, and maximum IOPS. For more information, see Primary ApsaraDB RDS instance types.
Capacity	The storage capacity that is provisioned to store data files, system files, log files, and transaction files in the RDS instance. You can adjust the storage capacity at a step size of 5 GB. Note A dedicated RDS instance that uses local disks exclusively occupies the allocated resources, and its storage capacity varies based on the instance type. For more information, see Primary ApsaraDB RDS instance types.

Click Next: Instance Configuration.

Configure the following parameters.

Parameter	Description
Network Type	The network type of the RDS instance. Select VPC. A virtual private cloud (VPC) is an isolated network that provides higher security and better performance than the classic network. If you select the VPC network type, you must configure the VPC and VSwitch of Primary Node parameters. If you set the Deployment Method parameter to Multi-zone Deployment in the Basic Configurations step, you must also configure the VSwitch of Secondary Node parameter. Note Make sure that the RDS instance and the ECS instance to which you want to connect have the same network type. If their network types are different, they cannot communicate over an internal network.
Resource Group	The resource group to which the RDS instance belongs.

Click Next: Confirm Order.
Confirm the settings in the Parameters section, specify the Purchase Plan and Duration parameters, read and select Terms of Service, click Pay Now, and then complete the payment. You must specify the Duration parameter only when the new RDS instance uses the subscription billing method.

Log on to the new RDS instance and verify the data

For more information, see Connect to an ApsaraDB RDS for PostgreSQL instance.

Migrate data to the original RDS instance

After you verify the data on the new RDS instance, you can migrate the data from the new RDS instance to the original RDS instance. For more information, see Migrate data between RDS instances.

Note

Data migration indicates the process of replicating the data of the source RDS instance to the destination RDS instance. Data migration does not interrupt the workloads on the source RDS instances.

Related operations

To restore data of specific databases or tables on an RDS instance, follow the instructions in Restore individual databases and tables.
To restore a small amount of data, such as the data of a table, you can use a logical backup file to quickly restore the data. For more information, see Use pg_restore to restore data from a logical backup file.
To restore the backup data of an RDS instance to a self-managed PostgreSQL instance, follow the instructions in Restore the data of an ApsaraDB RDS for PostgreSQL instance to a self-managed PostgreSQL instance by using a CSV file or an SQL file.