Reminds me of this interesting call out in <i>Postgres 16: The exciting and the unnoticed</i>:<p>> <i>Moving towards Active Active replication: A feature was committed in Postgres 16 to allow logical replication to avoid replication loops, which is when a transaction gets replicated from source to target and back. Postgres 16 allows subscribers to process only changes which have no origin which allows you to prevent these loops. Bi-directional active-active replication is still very complicated and requires solving a lot of problems, but this feature tackles one of those important sub-problems.</i><p><a href="https://tembo.io/blog/postgres-16/#laying-the-groundwork-for-an-exciting-postgres-17-and-beyond" rel="nofollow noreferrer">https://tembo.io/blog/postgres-16/#laying-the-groundwork-for...</a> <a href="https://news.ycombinator.com/item?id=37613690">https://news.ycombinator.com/item?id=37613690</a> (18d ago, 1 comment)<p>The AWS submission here is quite short. There's a longer read available at <a href="https://aws.amazon.com/blogs/database/using-pgactive-active-active-replication-extension-for-postgresql-on-amazon-rds-for-postgresql/" rel="nofollow noreferrer">https://aws.amazon.com/blogs/database/using-pgactive-active-...</a> that sheds some light on the basis for their technology:<p>> <i>pgactive is based on the open-source BDR project and includes functions that let you set up an active-active PostgreSQL cluster, conflict detection and automatic resolution methods (for example, last-write-wins), conflict monitoring, and more.</i><p>They link to this old BDR project wiki page <a href="https://wiki.postgresql.org/wiki/BDR_Project" rel="nofollow noreferrer">https://wiki.postgresql.org/wiki/BDR_Project</a> , but it's quite stale. Efforts seems to have been ongoing as EnterpriseDB, <a href="https://github.com/EnterpriseDB">https://github.com/EnterpriseDB</a> .<p>That's many of the same folks as behind the cloudnative-pg k8s operator. <a href="https://www.enterprisedb.com/blog/introducing-cloudnativepg-new-open-source-kubernetes-operator-postgres" rel="nofollow noreferrer">https://www.enterprisedb.com/blog/introducing-cloudnativepg-...</a> <a href="https://news.ycombinator.com/item?id=37616033">https://news.ycombinator.com/item?id=37616033</a> <a href="https://hn.algolia.com/?query=cloudnative-pg&sort=byDate" rel="nofollow noreferrer">https://hn.algolia.com/?query=cloudnative-pg&sort=byDate</a>