Postgres Pro
Downloads
Home   >   mailing lists

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

From Amit Kapila
Subject Re: Data loss on logical replication, 12.12 to 14.5, ALTER SUBSCRIPTION
Date
Msg-id CAA4eK1+Hh1Mx1-crjR0NuSQcsMb6sq9gFbRqP+ibShLGyT9otw@mail.gmail.com
Whole thread Raw
In response to Re: 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  (Michail Nikolaev <michail.nikolaev@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Dec 27, 2022 at 5:49 PM Michail Nikolaev
<michail.nikolaev@gmail.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.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Allow placeholders in ALTER ROLE w/o superuser
Next
From: "wangw.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply