dazzla76's comments

dazzla76 | 2 years ago | on: PostgreSQL 16 Bi-Directional Logical Replication

Unique constraints can still be used as long as you accommodate the multiple sources. Something as simple of increment by 2 and the servers alternative odd and even as the starting point.

I used to do this with 3 way DB2 LUW replication back when i was a DBA. It all needs a bit of thought but is fairly simple when it comes down to it.

page 1