Re: Logical Replication Sync Validation

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Robert Sjöblom <robert(dot)sjoblom(at)fortnox(dot)se>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical Replication Sync Validation
Date: 2023-04-18 08:29:37
Message-ID: 469D4738-C6EE-4D3C-841A-0A0370364FB1@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Apr 18, 2023, at 01:20, Robert Sjöblom <robert(dot)sjoblom(at)fortnox(dot)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 compare row 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 a subscriber.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Howroyd 2023-04-18 09:52:55 Re: Guidance on INSERT RETURNING order
Previous Message Robert Sjöblom 2023-04-18 08:20:07 Logical Replication Sync Validation