public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sbob <[email protected]>
To: [email protected]
Subject: struggling with logical replication and WAL segments removed even with max_slot_wal_keep_size = -1
Date: Sat, 3 Jan 2026 11:28:12 -0700
Message-ID: <[email protected]> (raw)
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]@[unknown] LOG: connection
received: host=10-173-12-128.masked.cc.com port=50000
2026-01-03 18:21:00.498 UTC [770693] postgres@cc LOG: replication
connection authorized: user=postgres
application_name=pg_1415516682_sync_1415489254_7242369616429431728
2026-01-03 18:21:01.301 UTC [770693] postgres@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@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@cc LOG: starting logical
decoding for slot "pg_1415516682_sync_1415489254_7242369616429431728"
2026-01-03 18:21:01.301 UTC [770693] postgres@cc DETAIL: Streaming
transactions committing after 9D6/AB9CE2B8, reading WAL from 9D6/AB9CE280.
2026-01-03 18:21:01.301 UTC [770693] postgres@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@cc ERROR: requested WAL
segment 00000002000009D6000000AB has already been removed
2026-01-03 18:21:01.301 UTC [770693] postgres@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@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
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: struggling with logical replication and WAL segments removed even with max_slot_wal_keep_size = -1
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox