logical replication, with a replication slot but still getting "requested WAL segment has already been removed" - Mailing list pgsql-admin

From Sbob
Subject logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
Date
Msg-id 47840565-33e4-4294-aee3-5fda21bd27e6@quadratum-braccas.com
Whole thread Raw
Responses Re: logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
List pgsql-admin

All;

We have setup logical replication for some very large tables, both publisher and subscriber are running postgresql v14, however even though the locical replication is using a replication slot we keep getting this error:

2025-12-21 23:25:50.452 UTC [2131314] LOG:  logical replication apply worker for subscription "bigtables_sub" has started
2025-12-21 23:25:50.987 UTC [2131314] ERROR:  could not receive data from WAL stream: ERROR:  requested WAL segment 000000020000089F00000098 has already been removed

Thanks for any help

pgsql-admin by date:

Previous
From: Pär Mattsson
Date:
Subject: Performance issue!
Next
From: Laurenz Albe
Date:
Subject: Re: logical replication, with a replication slot but still getting "requested WAL segment has already been removed"