Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL segments removed from primary despite the fact that logical replication slot needs it. - Mailing list pgsql-bugs

From Andres Freund
Subject Re: WAL segments removed from primary despite the fact that logical replication slot needs it.
Date
Msg-id 20221117185529.2q7quyznpdrcjqnx@awork3.anarazel.de
Whole thread Raw
In response to Re: WAL segments removed from primary despite the fact that logical replication slot needs it.  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: WAL segments removed from primary despite the fact that logical replication slot needs it.  (hubert depesz lubaczewski <depesz@depesz.com>)
List pgsql-bugs
Tree view 
Hi,

On 2022-11-17 23:22:12 +0900, Masahiko Sawada wrote:
> On Thu, Nov 17, 2022 at 5:03 PM Andres Freund <andres@anarazel.de> wrote:
> > > > 4. wal sender restarts for some reason (or server crashed).
> >
> > I don't think walsender alone restarting should change anything, but
> > crash-restart obviously would.
> 
> Right. I've confirmed this scenario is possible to happen with crash-restart.

Depesz, were there any crashes / immediate restarts on the PG 12 side? If so,
then we know what the problem likely is and can fix it. If not...


Just to confirm, the problem has "newly" occurred after you've upgraded to
12.12? I couldn't quite tell from the thread.

Greetings,

Andres Freund

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Server table rows permanently fixed (cannot be deleted or truncated)
Next
From: Jeff Davis
Date:
Subject: Re: Inaccurate documentation about identifiers