Re:AWS open-sourced Postgres active-active replication exten...
by xinu2020 on Wednesday July 16, 2025 @01:11PM
(#44584629)
Curious about this - How would local writes conflicting with remote updates be handled? I can't think of a merge strategy working on all scenario (or even most of the time)
[ Parent
| on HN ]
Re:AWS open-sourced Postgres active-active replication exten...
by nico on Wednesday July 16, 2025 @01:45PM
(#44584985)
Great question, I don't know. However, at least in my case, I wouldn't mind the source data always overwriting the local data. In fact, that's the way it works now when loading a newer snapshot, the local db is dropped and then re-built from the snapshot
Thinking about the developer experience though, when loading a snapshot manually, the dev knows they are overwriting their local db. However, if replication happened automatically/continuously on the background, it could lead to some really confusing/annoying behaviors