We have a cluster of 3 nodes in DC and a cluster of 3 nodes in DR. I need to sync DR leader from DC Leader keeping both cluster separated from each other. Though I got a solution of adding parameter standby_cluster from link: DC-DR Sync issue in Patroni PostgreSQL setup. But it is not working. I am guessing there must be something more to configure in patroni.yml file and I was hoping if anyone can help me in clarifying what are the necessary configuration required to add in patroni.yml for DC-DR Sync in Patroni Postgresql Setup.
Like,
what are the parameters to be considered in standby_cluster apart from host and port.
Do I need to change or add anything in dcs, postgresql.conf or pg_hba.conf section under patroni.yml file or anything in Consul?
Do I need to directly edit in patroni.yml or need to edit in "patronictl edit-config"?
Or is there any other method for DC to DR Syncing.
Setup in our Environment:
- Patroni: for Replication, handling database clustering
- Consul: for Network Discovery and Health Check
- Pgbackrest: for Backup & Restore
I tried adding parameter standby_cluster under dcs with mentioning Host, Port and create_replica_methods (- basebackup). Then I added sample data in DC Leader to verify but I couldn't find anything in DR instance.
