I have 7 nodes PostgreSQL, Etcd, Patroni cluster setup. In which, 3 nodes are on-premises and 4 nodes are on cloud. I want to make 1 master in on-premises setup and 1 master in cloud setup. I also want Master-Master Replication between on-premises and cloud setup. Is it possible? If yes then how?
Hi @deepak.kv
Master-Master setups are generally lots of cons and hard to manage and generally is not recommended, but we have blog post about that explained possible scenarions and such details that you can have a look https://www.percona.com/blog/multi-master-replication-solutions-for-postgresql/