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 1vtXZT-00Dun0-2A for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Feb 2026 20:57:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vtXZR-0098kF-11 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Feb 2026 20:57:53 +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 1vtXZR-0098k7-03 for pgsql-hackers@lists.postgresql.org; Fri, 20 Feb 2026 20:57:53 +0000 Received: from ma-mx04.apple.com ([17.23.4.22]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vtXZO-00000000PvT-07oe for pgsql-hackers@postgresql.org; Fri, 20 Feb 2026 20:57:52 +0000 Received: from mr55p01nt-mtap03.apple.com (mr55p01nt-mtap03.ise.apple.com [10.170.185.206]) by st47p01nt-mxp04.apple.com (Oracle Communications Messaging Server 8.1.0.28.20250821 64bit (built Aug 21 2025)) with ESMTPS id <0TAR15VLAZKA8810@st47p01nt-mxp04.apple.com> for pgsql-hackers@postgresql.org; Fri, 20 Feb 2026 20:57:48 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.51,FMLib:17.12.100.49 definitions=2026-02-20_03,2026-02-20_04,2025-10-01_01 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=apple.com; h=cc : content-transfer-encoding : content-type : date : from : in-reply-to : message-id : mime-version : references : subject : to; s=20180706; bh=L/ABok8/lTHjLUR1hC/DyQoykcDKU0csGDreYce1pLs=; b=cRhMLw48mCKNYT8ABVrEz3788Y9ic6JlDLDHooPNZj3znDQww+MZIYqgncolFl5KT/KG I6oWJLIo+wGyXmaSlyboOWMCtj2LUO2uOBmgRXEVkms4pIInBj3p1npWj1EzfpOBszL0 uUdGMkOnDKWlzBP8bOl+ojXdopThNh9dmQxzuIIgLr+hB0V2rRtvHqqyDk+Ebi8NnWdJ arJjnnbxI5riYKypZK7L49kZYTUkT4jmJJ/1MEz3hmEKJMJMIiZvlKkBpKNP30QsQvSO LDI9dW6suaUE4Yxe7ma492zv1XN5S/W1k6OWfuILLG3LE6upMkZaC0v0nOjiMwwLWrx4 ow== Received: from mr55p01nt-mmpp07.apple.com (mr55p01nt-mmpp07.ise.apple.com [10.170.185.196]) by mr55p01nt-mtap03.apple.com (Oracle Communications Messaging Server 8.1.0.28.20250821 64bit (built Aug 21 2025)) with ESMTPS id <0TAR009JDZKB0980@mr55p01nt-mtap03.apple.com>; Fri, 20 Feb 2026 20:57:47 +0000 (GMT) Received: from process_milters-daemon.mr55p01nt-mmpp07.apple.com by mr55p01nt-mmpp07.apple.com (Oracle Communications Messaging Server 8.1.0.28.20250821 64bit (built Aug 21 2025)) id <0TAR1MV00ZFRTE00@mr55p01nt-mmpp07.apple.com>; Fri, 20 Feb 2026 20:57:47 +0000 (GMT) X-Va-A: X-Va-T-CD: fbefea1c0c736bb43e645d6588f9be87 X-Va-E-CD: 9ce601a75b1f4e0714f9000a2b3f5f57 X-Va-R-CD: c1731c115b7610745dd09252c498fcc6 X-Va-ID: 0fe16ab1-35f6-4f23-b8bb-daa7a3c1d2a4 X-Va-CD: 0 X-V-A: X-V-T-CD: fbefea1c0c736bb43e645d6588f9be87 X-V-E-CD: 9ce601a75b1f4e0714f9000a2b3f5f57 X-V-R-CD: c1731c115b7610745dd09252c498fcc6 X-V-ID: b5374e34-47d1-43eb-9f4f-3d7a3bca9633 X-V-CD: 0 X-Proofpoint-Virus-Version: vendor=baseguard engine=ICAP:2.0.293,Aquarius:18.0.1121,Hydra:6.1.51,FMLib:17.12.100.49 definitions=2026-02-20_03,2026-02-20_04,2025-10-01_01 Received: from smtpclient.apple (unknown [17.233.6.61]) by mr55p01nt-mmpp07.apple.com (Oracle Communications Messaging Server 8.1.0.28.20250821 64bit (built Aug 21 2025)) with ESMTPSA id <0TAR1M7DLZKA8300@mr55p01nt-mmpp07.apple.com>; Fri, 20 Feb 2026 20:57:46 +0000 (GMT) Content-type: text/plain; charset=us-ascii MIME-version: 1.0 (Mac OS X Mail 16.0 \(3864.300.41.1.7\)) Subject: Re: Streaming replication and WAL archive interactions From: Harinath Kanchu In-reply-to: Date: Fri, 20 Feb 2026 12:57:35 -0800 Cc: hlinnaka@iki.fi, Michael Paquier , Robert Haas , Venkata Balaji N , Andres Freund , Fujii Masao , Borodin Vladimir , PostgreSQL-development , nkak@vmware.com, Roman Khapov , Kirill Reshke , ShirishaRao@vmware.com, x4mmm@yandex-team.ru Content-transfer-encoding: quoted-printable Message-id: <41D301A5-AB81-4B21-8AC1-9DD602362D31@apple.com> References: <548AF1CB.80702@vmware.com> <689EB259-44C2-4820-B901-4F6B1C55A1E4@simply.name> <549083D6.1000301@vmware.com> <54949108.3030109@vmware.com> <552FA38F.9060005@iki.fi> <5535FE71.1010905@iki.fi> <55362CAD.2000207@iki.fi> <553741FE.1080403@iki.fi> <554CB84E.3070406@iki.fi> <5550D20D.6090703@iki.fi> To: pgsql-hackers@postgresql.org X-Mailer: Apple Mail (2.3864.300.41.1.7) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi All, I posted about this last year [1] -- sharing our experience hitting WAL archival gaps in production and asking for last_archived_wal to be surfaced on the standby via keep-alive messages. Glad to see Andrey's patch reviving this. If the full shared mode lands, great. But even if that's too much for now, just exposing last_archived_wal on the standby -- in pg_stat_wal_receiver or anywhere queryable -- would unblock everyone solving this problem externally. [1] = https://www.postgresql.org/message-id/flat/CAO7WNRTBrPn0WU9GTimoK-0FHRynaU= Ha34%3DAp5puCzEipNymFg%40mail.gmail.com Thanks, Harinath=