Hello, Is the requirement only to being able to restore the database to a previous point in time? If yes, then this can be done without any replication, just with regular database backups.
When people speak about replicas, this means there is a secondary instance that is receiving all the changes in (near) real time, but it doesn't seam to me you're asking for that?
for managed database offering you can set backup 0-35 days and for issues or rollback you can do a point in time for that period to a new instance. thus any schema changes could be rolled back as long as the change was done in last n days (n=backup days set on instance )
DMS Migration MongoDB source and RDS Postgres as destinationAccepted Answerasked 4 months ago
RDS Upgrade - Postgres 12.7 -> Aurora - best way with zero or little downtimeasked 9 months ago
"schema with OID does not exist" error during Postgres 12.8 to 13.6 upgradeasked 5 months ago
Cannot upgrade nor restore PostgreSQL 9.4 RDS snapshotasked 2 months ago
RDS Postgres major upgrade from 12 to 13 failsasked 15 days ago
aurora postgres major upgrade - pg_dumpallasked 4 years ago
Database Migrationasked 21 days ago
Enable RDS Encryption with minimal downtime after creationAccepted Answerasked 2 years ago
Postgres RDS Schema Upgrade (migration) with no downtimeasked 6 months ago
How to create SSL dblink connection from RDS to postgres on premise?asked 8 months ago