RDS PostgreSQL offers multiple disaster recovery solutions with different RTO, RPO, and cost trade-offs to ensure business continuity and high availability.
Comparison of disaster recovery solutions
-
RTO (Recovery Time Objective): the time from failure occurrence until the system is restored to an available state.
-
RPO (Recovery Point Objective): the maximum tolerable data loss duration during a disaster or system failure.
|
Solution |
RTO |
RPO |
Price |
Advantages |
Disadvantages |
Scenarios |
|
Typically 10 to 30 seconds |
Within 5 minutes, typically 30 seconds to 1 minute |
Medium |
|
Both source and disaster recovery instances must be RDS PostgreSQL with consistent major versions. |
Cross-region disaster recovery between RDS PostgreSQL instances, or cross-region read-only access. |
|
|
Typically 10 to 30 seconds |
Within 5 minutes, typically 30 seconds to 1 minute |
Slightly high |
|
You must ensure network connectivity and bear the associated network costs. |
On-premises or third-party cloud instances that need RDS PostgreSQL as a disaster recovery target. |
|
|
Typically hours |
Within 5 minutes, typically 30 seconds to 1 minute |
Low |
|
|
Cross-region disaster recovery for RDS PostgreSQL without strict recovery time requirements. |
|
|
Data synchronization (DTS) |
Typically 10 to 30 seconds |
Within 5 minutes, typically 30 seconds to 1 minute |
High |
|
Data synchronization is at the database level. When the number of instance databases is large, the cost is higher. |
Partial database disaster recovery or multi-active deployments. |