Disclaimer: This article may contain information about third-party products. Such information is for reference only. Alibaba Cloud does not make any guarantee, express or implied, with respect to the performance and reliability of third-party products, as well as potential impacts of operations on the products.
Overview
This article describes how to create a standby RDS PostgreSQL database.
Detail
Alibaba Cloud reminds you that:
- Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
- You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
- If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.
Establish a standby Kube-based service
You can create a new apsaradb RDS for PostgreSQL database as a secondary database, synchronize PostgreSQL data from the primary database to the secondary database, and then implement real-time data synchronization between the secondary database by using the logical subscription feature. For detailed operation steps, refer to the following:
- Log on to the RDS console. See restore PostgreSQL data to create a new database as a secondary database and synchronize data to the primary database.
- Using the logical subscription feature, you can synchronize data from the primary database to the secondary database in real time.
Application scope
- ApsaraDB RDS for PostgreSQL