Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions

On Mon, Sep 4, 2023 at 05:55:51PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 18084
> Logged by: Git Queries
> Email address: gitqueries0(at)gmail(dot)com
> PostgreSQL version: Unsupported/Unknown
> Operating system: Microsoft Windows Server 2019 Standard
> Description:
>
> Version - PostgreSQL 10.20, compiled by Visual C++ build 1800, 64-bit
>
> Platform - Windows
>
> Regarding PostgreSQL, during the migration from PG 10.20 to 14.7, we will
> perform a sanity check on the migrated tables using source and destination
> row counts. Occasionally, we encounter count mismatches where the source
> database has fewer rows, resulting in a higher count, or more rows,
> resulting in a lower count.
>
> Note: There are no migration issues, as all data rows have been successfully
> migrated without data loss.

And how did you perform this migration? pg_dump, pg_upgrade, logical
replication?

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.