On Mon, Aug 26, 2024 at 1:30 PM <masahiro.ik...@nttdata.com> wrote: > > When I read the following documentation related to the > "synchronized_standby_slots", I misunderstood that data loss would not occur > in the case of synchronous physical replication. However, this is incorrect > (see reproduce.txt). > > > Note that in the case of asynchronous replication, there remains a risk of > > data loss for transactions committed on the former primary server but have > > yet to be replicated to the new primary server. > https://www.postgresql.org/docs/17/logical-replication-failover.html > > Am I missing something? >
It seems part of the paragraph: "Note that in the case of asynchronous replication, there remains a risk of data loss for transactions committed on the former primary server but have yet to be replicated to the new primary server." is a bit confusing. Will it make things clear to me if we remove that part? I am keeping a few others involved in this feature development in Cc. -- With Regards, Amit Kapila.