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.94.2) (envelope-from ) id 1uwiOm-006Zdk-Bn for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Sep 2025 14:35:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uwiOk-007zt6-Hi for pgsql-bugs@arkaria.postgresql.org; Thu, 11 Sep 2025 14:35:42 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uwbRZ-006FZM-FQ for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 07:10:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1uwbRV-0009Fs-1Q for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 07:10:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=4kbCJxKR476xOYN90sBdYgG0DkGvLuJajfLS42QMiuk=; b=1b/zCaneaqUuV1H66r3NMrBh/9 Nr0ibZWLhJPSQCCfj33t5lqDbP9n9JlFUe9a4kqLI/GIV7klgpysR1ssyXlpunDbgKTBNAeLo1azW mNcMayuZBsFqn28ePn9QPm5rkKunndRb7+cB8ocdIgjxg1mDWYE9eevrxtsUDPB4jP7PW4rQWUzYa vgML2guRtjVHp3PVbU5+itw3gY+LGLkWsI7auz60sQ76QI/Q3OfqvdIP1t5uae09qGHxEcmMeMmfJ f8BHLKY0cCOv0DizUamwncKAbH8YOYWIcpY73W1l1+vKgaxe5SBmhGnP3NKXLl1tsm2r+OtOmDQz1 qdk1qkaA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uwbRU-004X0y-QI for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 07:10:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1uwbRT-008G73-0d for pgsql-bugs@lists.postgresql.org; Thu, 11 Sep 2025 07:10:03 +0000 Content-Type: multipart/mixed; boundary="===============6213725812388317398==" MIME-Version: 1.0 Subject: BUG #19047: pg_last_wal_replay_lsn() returns non-NULL after pg_promote() To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mahadevan@rapidloop.com Reply-To: mahadevan@rapidloop.com, pgsql-bugs@lists.postgresql.org Date: Thu, 11 Sep 2025 07:09:36 +0000 Message-ID: <19047-0494c16d796fea52@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6213725812388317398== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxOTA0NwpMb2dnZWQgYnk6ICAgICAgICAgIE1haGFkZXZhbiBSYW1hY2hh bmRyYW4KRW1haWwgYWRkcmVzczogICAgICBtYWhhZGV2YW5AcmFwaWRsb29wLmNvbQpQb3N0Z3Jl U1FMIHZlcnNpb246IDE3LjYKT3BlcmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTIsIGFtZDY0CkRl c2NyaXB0aW9uOiAgICAgICAgCgpBZnRlciBwcm9tb3RpbmcgYSBzdGFuZGJ5IHRvIGEgcHJpbWFy eSB1c2luZyBwZ19wcm9tb3RlKCksIGl0IGlzIGV4cGVjdGVkCnRoYXQgdGhlIHNlcnZlciBpcyBu b3QgYSBwcmltYXJ5IGFuZCBkb2VzIG5vdCAvIGNhbm5vdCByZXBsYXkgV0FMcywgYW5kCnRoZXJl Zm9yZSBwZ19sYXN0X3dhbF9yZXBsYXlfbHNuKCkgc2hvdWxkIHJldHVybiBOVUxMLiBIb3dldmVy LCBpdCBkb2VzIG5vdC4KClRvIHJlcHJvZHVjZSwgc2V0dXAgYSBwcmltYXJ5IGFuZCBhIHN0YW5k YnksIGFuZCBydW4gdGhlIGZvbGxvd2luZyBjb21tYW5kcwpvbiB0aGUgc3RhbmRieToKCiQgcHNx bCAtaCAvdG1wIC1wIDgwMDEgcG9zdGdyZXMKTnVsbCBkaXNwbGF5IGlzICJ+Ii4KcHNxbCAoMTcu NiAoRGViaWFuIDE3LjYtMS5wZ2RnMTIrMSkpClR5cGUgImhlbHAiIGZvciBoZWxwLgoKcG9zdGdy ZXM9IyBzZWxlY3QgcGdfbGFzdF93YWxfcmVwbGF5X2xzbiAoKTsKIHBnX2xhc3Rfd2FsX3JlcGxh eV9sc24KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAwLzQwNDM0RTAKKDEgcm93KQoKcG9zdGdy ZXM9IyBzZWxlY3QgcGdfcHJvbW90ZSgpOwogcGdfcHJvbW90ZQotLS0tLS0tLS0tLS0KIHQKKDEg cm93KQoKcG9zdGdyZXM9IyBzZWxlY3QgcGdfbGFzdF93YWxfcmVwbGF5X2xzbiAoKTsKIHBnX2xh c3Rfd2FsX3JlcGxheV9sc24KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCiAwLzQwNDM0RTAKKDEg cm93KQoKcG9zdGdyZXM9IyBzZWxlY3QgcGdfaXNfaW5fcmVjb3ZlcnkoKTsKIHBnX2lzX2luX3Jl Y292ZXJ5Ci0tLS0tLS0tLS0tLS0tLS0tLS0KIGYKKDEgcm93KQoKQXQgdGhpcyBwb2ludCwgdGhl IHNlcnZlciBpcyBhIHByaW1hcnksIGJ1dCBzdGlsbCByZXBvcnRzCnBnX2xhc3Rfd2FsX3JlcGxh eV9sc24oKSBhcyBub24tTlVMTC4KCldlJ3JlIHJlcG9ydGluZyB0aGlzIGZyb20gYSByZWFsIGN1 c3RvbWVyIGlzc3VlIG9uIHRoZSBmaWVsZC4KCkJlc3QsCi1NYWhhZGV2YW4KKHBnRGFzaCAtIGh0 dHBzOi8vcGdkYXNoLmlvKQoK --===============6213725812388317398==--