Postgres Pro
Downloads
Home   >   mailing lists

RE: Potential data loss due to race condition during logical replication slot creation - Mailing list pgsql-bugs

From Hayato Kuroda (Fujitsu)
Subject RE: Potential data loss due to race condition during logical replication slot creation
Date
Msg-id TYCPR01MB120771B4C477C9677031F0D9BF52C2@TYCPR01MB12077.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Potential data loss due to race condition during logical replication slot creation  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-bugs
Tree view 
Dear Amit,

> 
> Won't it be possible to achieve the same thing if we just save
> (serialize) the highest xid among all running xacts?
>

Indeed, here is an updated version.
Since the array in xl_running_xact is not ordered, entries of it must be seeked
and found the highest one.

Best Regards,
Hayato Kuroda
FUJITSU LIMITED
https://www.fujitsu.com/
Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: ReplicationSlotRelease may set the statusFlags of other processes in PG14
Next
From: Dave Cramer
Date:
Subject: Re: Postgres jdbc driver inconsistent behaviour with double precession