struggling with logical replication and WAL segments removed even with max_slot_wal_keep_size = -1

From: Sbob <sbob(at)quadratum-braccas(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: struggling with logical replication and WAL segments removed even with max_slot_wal_keep_size = -1
Date: 2026-01-03 18:28:12
Message-ID: e0c88962-07a4-400b-84d6-b7d142a36ac1@quadratum-braccas.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All;

we have been fighting logical replication for some timetgres v14, 
max_slot_wal_keep_size = -1 but I still get this kind of error on the
publisher every few days:

2026-01-03 18:21:00.497 UTC [770693] [unknown](at)[unknown] LOG: connection
received: host=10-173-12-128.masked.cc.com port=50000
2026-01-03 18:21:00.498 UTC [770693] postgres(at)cc LOG:  replication
connection authorized: user=postgres
application_name=pg_1415516682_sync_1415489254_7242369616429431728
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc LOG:  received
replication command: START_REPLICATION SLOT
"pg_1415516682_sync_1415489254_7242369616429431728" LOGICAL 9D6/AB9CE2B8
(proto_version '2', publication_names '"sit_cc_ch_pub"')
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc STATEMENT:
START_REPLICATION SLOT
"pg_1415516682_sync_1415489254_7242369616429431728" LOGICAL 9D6/AB9CE2B8
(proto_version '2', publication_names '"sit_cc_ch_pub"')
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc LOG:  starting logical
decoding for slot "pg_1415516682_sync_1415489254_7242369616429431728"
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc DETAIL: Streaming
transactions committing after 9D6/AB9CE2B8, reading WAL from 9D6/AB9CE280.
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc STATEMENT:
START_REPLICATION SLOT
"pg_1415516682_sync_1415489254_7242369616429431728" LOGICAL 9D6/AB9CE2B8
(proto_version '2', publication_names '"sit_cc_ch_pub"')
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc ERROR:  requested WAL
segment 00000002000009D6000000AB has already been removed
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc STATEMENT:
START_REPLICATION SLOT
"pg_1415516682_sync_1415489254_7242369616429431728" LOGICAL 9D6/AB9CE2B8
(proto_version '2', publication_names '"sit_cc_ch_pub"')
2026-01-03 18:21:01.301 UTC [770693] postgres(at)cc LOG: disconnection:
session time: 0:00:00.805 user=postgres database=cc
host=10-173-12-128.ssnc-corp.cloud port=50000

any advice would be greatly appreciated, thanks in advance

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Sbob 2026-01-03 18:36:23 logical replication via log shipping
Previous Message Ibrahim Shaame 2026-01-02 18:23:58 Unable to compile postgresql-18.1