Patroni and logical replication fo PostgreSQL: Preventing data loss during failovers

This article explores how data loss can occur in PostgreSQL environments using both physical and logical replication during a Patroni-managed failover. It specifically highlights that when replicas are configured with the `nofailover: true` tag, the lack of automatic logical slot creation can lead to missed transactions if the original leader becomes unavailable during a manual switchover.