Hi everyone, interesting problem. I have identical Postgres databases in the US and UK and I want to do multi-master replication across the databases (i.e. both databases sync and both have read-write access). I am thinking of using CDC with Airbytes to create a master database, so the data flow would look something like (updates from US Postgres) -> |master database| <- (updates from UK Postgres). I would then do (US database receives updates from UK) <- |master database| -> (UK database receives updates from US) through CDC. I'm not sure if this would work since if I configured the master database with CDC it would log updates from the source database, and then propagate the updates back to the same database, creating duplicates. Is there any way around this? I think Airbytes might not be the solution for this.

If you're thinking to dump this data in different tables won't be a problem. But if you're goal is to achieve data replicas between databases I don't think it'll work.