Re: synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Laurenz, Thank you for the quick response. Could you please point me to the link where the "two-phase commit" approach is being discussed. I can track it for my reference. On Fri, Jun 23, 2023 at 3:26 PM Laurenz Albe wrote: > On Fri, 2023-06-23 at 15:05 +0530, Postgres all-

synchronous_commit= remote_apply | "The transaction has already committed locally..."

Hi Team, *Context: *We have faced a network isolation and ended-up with locally committed data on the old primary database server as one of the tools that is in-place for HA decided to promote one of the SYNC standby servers. As the PostgreSQL won't provide a HA solution as in-built, I would like