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

Поиск
Список
Период
Сортировка
От Sbob
Тема logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
Дата
Msg-id 47840565-33e4-4294-aee3-5fda21bd27e6@quadratum-braccas.com
обсуждение исходный текст
Ответы Re: logical replication, with a replication slot but still getting "requested WAL segment has already been removed"
Список 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 по дате отправления: