Active Active in Postgres 16
crunchydata.com
crunchydata.com
> Now both rows are out of sync. In pg1, the update of the email was lost and in pg2 the update of last_name was lost. This happens because the entire row is sent over during logical replication and not just the fields that were updated. In such cases, even eventual consistency is not possible.
Hmm, this makes it seem rather useless. Or at least not useful for what I would expect: keeping two Postgres instances in sync.