Everyone knows that asynchronous replication failovers — whether performed by Patroni or another tool — can result in lost data. This occurs in situations where certain transactions committed on the leader haven’t managed to reach the replica before a failover.
However, even if the replica is fully in sync with the leader, data loss during a failover may still occur...