RE: Doc: fix the note related to the GUC "synchronized_standby_slots"

masahiro.ikeda@nttdata.com

From: <Masahiro.Ikeda@nttdata.com>
To: <amit.kapila16@gmail.com>
Cc: <pgsql-hackers@lists.postgresql.org>, <Masao.Fujii@nttdata.com>
Date: 2024-08-27T09:35:24Z
Lists: pgsql-hackers
> So, will it be okay if we just remove ".. without losing data" from the sentence? Will that
> avoid the confusion you have?
Yes. Additionally, it would be better to add notes about data consistency after failover for example

Note that data consistency after failover can vary depending on the configurations. If
"synchronized_standby_slots" is not configured, there may be data that only the subscribers hold,
even though the new primary does not. Additionally, in the case of asynchronous physical 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.

Regards,
--
Masahiro Ikeda
NTT DATA CORPORATION



Commits

  1. Doc: Fix the ambiguity in the description of failover slots.