Re: Records count mismatch with logical replication - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Records count mismatch with logical replication
Date
Msg-id e1bd37c2-9e2c-4914-b8be-bd75b633dfc1@aklaver.com
Whole thread Raw
In response to Records count mismatch with logical replication  (Durgamahesh Manne <maheshpostgres9@gmail.com>)
Responses Re: Records count mismatch with logical replication
List pgsql-general
On 1/21/25 04:08, Durgamahesh Manne wrote:
> Hi  Team,
> 
> I have publication and subscription servers .So seems data replication 
> running with minimal lag but records count mismatch with more than 10 
> thousand records between source and destination tables
> 
> Could you please help in resolving this issue?

Not without a good deal more information:

1) Postgres version on either side of the replication.

2) The replication configuration.

3) Define how lag is being calculated and what 'minimal' is.

4) Define how the record counts are being derived.

5) The network distance between the servers.

> 
> Regards,
> Durga Mahesh
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com




pgsql-general by date:

Previous
From: Dominique Devienne
Date:
Subject: Re: Design of a reliable task processing queue
Next
From: Adrian Klaver
Date:
Subject: Re: