I got an AWS question and implemented it to make sure that the option is correct. A critical financial application runs on RDS for PostgreSQL. The requirements are tight: 1-second RPO, 60-second RTO, and database credentials rotated every 30 days without taking the application offline.
Source: [Dev.to](https://dev.to/aws-builders/rds-high-availability-and-credential-rotation-without-downtime-5fpj)