logical replication, with a replication slot but still getting "requested WAL segment has already been removed"

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
Date: 2025-12-22 21:14:39
Message-ID: 47840565-33e4-4294-aee3-5fda21bd27e6@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-12-23 10:17:15 Re: logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
Previous Message Pär Mattsson 2025-12-22 16:38:13 Re: Performance issue!