Re: Records count mismatch with logical replication

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