From: | Git Queries <gitqueries0(at)gmail(dot)com> |
---|---|
To: | Bruce Momjian <bruce(at)momjian(dot)us> |
Cc: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions |
Date: | 2023-09-06 17:41:05 |
Message-ID: | CALTThcZtn8fMUUz521yQvp8=czmUn03_uRyNbwOHhmizQyfOHQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
> And how did you perform this migration? pg_dump, pg_upgrade, logical
> replication?
Migration was performed using pg_dump.
On Tue, Sep 5, 2023 at 8:48 PM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> 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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2023-09-06 18:02:19 | Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions |
Previous Message | Git Queries | 2023-09-06 17:40:50 | Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions |