Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vc6MR-0025i6-05 for pgsql-admin@arkaria.postgresql.org; Sat, 03 Jan 2026 18:28:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vc6MP-00DIdI-0Y for pgsql-admin@arkaria.postgresql.org; Sat, 03 Jan 2026 18:28:21 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vc6MO-00DId9-07 for pgsql-admin@lists.postgresql.org; Sat, 03 Jan 2026 18:28:21 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vc6MK-0040je-0R for pgsql-admin@lists.postgresql.org; Sat, 03 Jan 2026 18:28:19 +0000 Received: from phl-compute-01.internal (phl-compute-01.internal [10.202.2.41]) by mailfout.phl.internal (Postfix) with ESMTP id 6C776EC00CD; Sat, 3 Jan 2026 13:28:14 -0500 (EST) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-01.internal (MEProxy); Sat, 03 Jan 2026 13:28:14 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= quadratum-braccas.com; h=cc:content-transfer-encoding :content-type:content-type:date:date:from:from:in-reply-to :message-id:mime-version:reply-to:subject:subject:to:to; s=fm1; t=1767464894; x=1767551294; bh=Nyezb4uyeJlUDXTxrxjQ1c2SgK0B30F5 uMYy9t9Z2jU=; b=iaGYuvBFngvo+Yynvstss0BfqI0awcqhnZV+YJk58x+riBXU 95iFq8lfnClU7QbpYjMF/T6RRwOpSg7IaXe3dfEJuIWw85Kp/IFVT4Ck9fxNulvi yecv52D8U6xdHwB0g0cW8TKjOTfQrXkokJ2/MjQsauLPeCjZT1AMPR3vRzKM32o3 JXdCWSdrrqOxjeZgQI1GW0557zwzPzQPLrpKLAWSlwPZ9coaL04D21tNCQi6O8DF mB5lgA6JbWux4TiP9xpf3wD5EMt/btbwI1unFWV/YSUWPyr+YiCCeMven7i+Tuhl DLncoB/2nwq4wpnKyk9Za7Nrn8MZR6gNJCqdTg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:message-id:mime-version:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; t= 1767464894; x=1767551294; bh=Nyezb4uyeJlUDXTxrxjQ1c2SgK0B30F5uMY y9t9Z2jU=; b=YOcCIpLbl8rY1mPC4VzgONrrCg0pwXj/289enlpS+d6lijE9iCG bBw0R13Zzxl4feytEE06udFqQLUCDJ2iopCp5nVyPfk1aCQYArwurLK9se9TZGyB IO/RhqLyQ5DPoRZiQVeXwpZiolsHZ3fDpUX3eyFgQ09wDX9FUG4Imw8GbCliugtZ fn8T8fvSJyBwYxgdXrHpvMVHEXVJtmDdaQ6xiElUhelor/ncQyUUy5+urMaB8nbH Ng3EgvNZLIo38kCybFwOIpMx3CwpYQ5BrR8NBU3dNJUUgL+QXBTjqfyNTWDxHRKi C8xGu99iFJnZFqXV4o7bPd2fsH78LeEzs0A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdelvddviecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecunecujfgurhepkfffgggfvffhufgtgfesthekredttddvje enucfhrhhomhepufgsohgsuceoshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghs rdgtohhmqeenucggtffrrghtthgvrhhnpeefkeehffdtffeluddugeekvedtkedvjefgge ehfeetfeduieevkefhleffhfeuhfenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgr mhepmhgrihhlfhhrohhmpehssghosgesqhhurggurhgrthhumhdqsghrrggttggrshdrtg homhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpdhrtghpthhtohep phhgshhqlhdqrggumhhinheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtg hpthhtohepshgsohgssehquhgrughrrghtuhhmqdgsrhgrtggtrghsrdgtohhm X-ME-Proxy: Feedback-ID: i374947ac:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 3 Jan 2026 13:28:13 -0500 (EST) Message-ID: Date: Sat, 3 Jan 2026 11:28:12 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird To: pgsql-admin@lists.postgresql.org Content-Language: en-US From: Sbob Subject: struggling with logical replication and WAL segments removed even with max_slot_wal_keep_size = -1 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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