On Mon, Aug 26, 2024 at 1:30 PM <Masahiro.Ikeda@nttdata.com> wrote:
>
> When I read the following documentation related to the "synchronized_standby_slots", I misunderstood that data loss
wouldnot 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
theformer 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.