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

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Michail Nikolaev <michail(dot)nikolaev(at)gmail(dot)com>
Cc: 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-28 04:33:09
Message-ID: CAA4eK1+Hh1Mx1-crjR0NuSQcsMb6sq9gFbRqP+ibShLGyT9otw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Dec 27, 2022 at 5:49 PM Michail Nikolaev
<michail(dot)nikolaev(at)gmail(dot)com> wrote:
>
>
> Probably a small part of WAL was somehow skipped by logical worker in
> all that mess.
>

None of these entries are from the point mentioned by you [1]
yesterday where you didn't find the corresponding data in the
subscriber. How did you identify that the entries corresponding to
that timing were missing?

[1] -
> 2022-12-14 09:49:31.340
> 2022-12-14 09:49:41.683

--
With Regards,
Amit Kapila.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message wangw.fnst@fujitsu.com 2022-12-28 04:38:58 RE: Perform streaming logical transactions by background workers and parallel apply
Previous Message Tom Lane 2022-12-28 04:29:40 Re: Allow placeholders in ALTER ROLE w/o superuser