Feedback-ID: i374947ac:Fastmail
Content-Type: multipart/alternative;
 boundary="------------3M85Hlp8lMyAE8t1v1fMlejw"
Message-ID: <47840565-33e4-4294-aee3-5fda21bd27e6@quadratum-braccas.com>
Date: Mon, 22 Dec 2025 14:14:39 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
To: pgsql-admin@lists.postgresql.org
Content-Language: en-US
From: Sbob <sbob@quadratum-braccas.com>
Subject: logical replication, with a replication slot but still getting
 "requested WAL segment has already been removed"
Archived-At: 
 <https://www.postgresql.org/message-id/47840565-33e4-4294-aee3-5fda21bd27e6%40quadratum-braccas.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------3M85Hlp8lMyAE8t1v1fMlejw
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------3M85Hlp8lMyAE8t1v1fMlejw
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>All;<br>
      <br>
      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:<br>
      <br>
    </p>
    <p>
      <span style="font-family:monospace"><span
          style="color:#000000;background-color:#ffffff;">2025-12-21
          23:25:50.452 UTC [2131314] LOG:  logical replication apply
          worker for subscription "bigtables_sub" has started</span></span><br>
      <span style="font-family:monospace"><span
          style="color:#000000;background-color:#ffffff;">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</span><br>
        <span style="color:#000000;background-color:#ffffff;">
        </span><br>
      </span>Thanks for any help</p>
  </body>
</html>

--------------3M85Hlp8lMyAE8t1v1fMlejw--