Postgres Pro
Downloads
Home   >   mailing lists

Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION - Mailing list pgsql-hackers

From Michail Nikolaev
Subject Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION
Date
Msg-id CANtu0ohUZd3w4U82b9fktUoioe8dajWNS3wuAgjXvUgPzc_2XQ@mail.gmail.com
Whole thread Raw
In response to Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION  (Michail Nikolaev <michail.nikolaev@gmail.com>)
Responses Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
Tree view 
Hello again.

Just small a fix for:

> 2022-12-14 09:21:25.705 to
> 2022-12-14 09:49:20.664 (after synchronization start, but before finish).

Correct values are:

2022-12-14 09:49:31.340
2022-12-14 09:49:41.683

So, it looks like we lost about 10s of one of the tables WAL.

pgsql-hackers by date:

Previous
From: Michail Nikolaev
Date:
Subject: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION
Next
From: Masahiko Sawada
Date:
Subject: Re: [PoC] Improve dead tuple storage for lazy vacuum