4 ms·
does it support two-phase commit? What if local transaction succeeded, and remote failed? Cluster will have inconsistent data?..
by riku_iki 4y ago
does it support two-phase commit? What if local transaction succeeded, and remote failed? Cluster will have inconsistent data?..
- CuriouslyC 4y agoThe mental model is slightly different. FDWS are basically server -> server linkages, not literally clustering. As a result, data consistency between servers is less of an issue - the data is likely to only live in one place (read replicas and failovers notwithstanding). There may be some error handling and try/rollback around remote transactions baked into postgres_fdw but I'm not familiar enough to say.