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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions
Дата
Msg-id ZPdG3AssVVDTpqtb@momjian.us
обсуждение исходный текст
Ответ на BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #18084: Count Mismatch Challenges During PostgreSQL Database Migration: Causes and Solutions  (Git Queries <gitqueries0@gmail.com>)
Список pgsql-bugs
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@gmail.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@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



В списке pgsql-bugs по дате отправления:

Предыдущее
От: Duke Astar
Дата:
Сообщение: Re: BUG #18086: compilation failed due to epoll_create1 not present
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: BUG #18088: Table Corruption Issues Arising from Abrupt Server Shutdown During PostgreSQL 10.20 to 14.7 Migratio