Feedback-ID: i76984098:Fastmail
Message-ID: <e1bd37c2-9e2c-4914-b8be-bd75b633dfc1@aklaver.com>
Date: Tue, 21 Jan 2025 07:54:29 -0800
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Records count mismatch with logical replication
To: Durgamahesh Manne <maheshpostgres9@gmail.com>,
 pgsql-general <pgsql-general@lists.postgresql.org>
References: <CAJCZko+gYNGiixGcqKAhjhLhUZ3QQg2rGs6nH7ZUNwTtjYLfGw@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAJCZko+gYNGiixGcqKAhjhLhUZ3QQg2rGs6nH7ZUNwTtjYLfGw@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/e1bd37c2-9e2c-4914-b8be-bd75b633dfc1%40aklaver.com>
Precedence: bulk

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