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

2023-06-23 Thread Laurenz Albe
On Fri, 2023-06-23 at 16:23 +0530, Postgres all-rounder wrote: > Could you please point me to the link where the "two-phase commit" approach > is being discussed. > I can track it for my reference. I looked, and didn't find it. I must have mis-remembered. There is this proposal: https://www.pos

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

2023-06-23 Thread Postgres all-rounder
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-rounder wrote: >

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

2023-06-23 Thread Laurenz Albe
On Fri, 2023-06-23 at 15:05 +0530, Postgres all-rounder wrote: > 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 P

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

2023-06-23 Thread Postgres all-rounder
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