Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION

From: Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION
Date: 2022-12-26 15:19:35
Message-ID: CANtu0ohUZd3w4U82b9fktUoioe8dajWNS3wuAgjXvUgPzc_2XQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2022-12-26 17:13:43 Re: [PoC] Improve dead tuple storage for lazy vacuum
Previous Message Michail Nikolaev 2022-12-26 14:28:00 Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION