My understanding, reading between the lines, is that BDR replicates row by row, starting after the COMMIT. I have a requirement to be able to then wait until some nodes have actually replicated my latest commit. If not, I will report the problem upstream. And maybe mark the transaction as dubious on the local db, which will hopefully also get replicated.
bdr.bdr_node_slots seems to tell me a pg_lsn of the latest replication of each node. But I need to know the pg_lsn of my last transaction. Knowing the current state of the db now that transaction committed would be close enough.
I could only find pg_current_xlog_insert_location(), but it looks different.
Asked by Tuntable
(143 rep)
May 31, 2017, 05:37 AM
Last activity: Sep 12, 2021, 01:08 AM
Last activity: Sep 12, 2021, 01:08 AM