2 Risposte
- Più recenti
- Maggior numero di voti
- Maggior numero di commenti
1
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?
Regards
con risposta 2 anni fa
0
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 )
con risposta 2 anni fa
Contenuto pertinente
- AWS UFFICIALEAggiornata 3 anni fa
Yeah I would ask the same as ADolganov mentioned that are we talking about read replica or backups/snapshots?
For replicas: We can use native RDS Read Replica or We can use DMS to create replication between two PostreSQL instances. (RDS PostgreSQL to RDS PostgreSQL or RDS PG to on-prem PG or RDS PG to Aurora).
By the way, DMS does support DDL change add columns and create tables: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.SupportedDDL.html but test is suggested before applying this to Production.