Multiple sync replicas
Author: jamessewellCreated May 29, 2020Updated Jun 30, 2025
From what I can gather patroni still supports one sync replica. I have a situation where would like to deploy to k8s cluster which has a controlplane spanning data centres. I need to guarantee zero data loss when a DC is lost.
Ideally I would have one three databases per DC with a sync replica at each site. Ideally a failover would prefer a local replica (although this isn’t a requirement).
Worst case just one sync replica at the other site. Obviously a failover complicates matters as if a DC was down just a single local replica would do.
Do I have any chance of making this work?
Source: patroni/patroni