Re: Logical Replication Sync Validation - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Logical Replication Sync Validation
Date
Msg-id 469D4738-C6EE-4D3C-841A-0A0370364FB1@thebuild.com
Whole thread Raw
In response to Logical Replication Sync Validation  (Robert Sjöblom <robert.sjoblom@fortnox.se>)
List pgsql-general

> On Apr 18, 2023, at 01:20, Robert Sjöblom <robert.sjoblom@fortnox.se> wrote:
> Another idea we've had would be to use CTID to fetch the last row (update/insert) in each table on both sides and
comparerow content, is this feasible? Is it safe to rely on CTIDs across logical replication? 

No.  CTIDs aren't sent over as part of logical replication, and there's no way to compare them between a publisher and
asubscriber. 


pgsql-general by date:

Previous
From: Robert Sjöblom
Date:
Subject: Logical Replication Sync Validation
Next
From: John Howroyd
Date:
Subject: Re: Guidance on INSERT RETURNING order