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 1u2mtf-005xFU-6F for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 08:04:27 +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 1u2mtd-009jB5-IL for pgsql-committers@arkaria.postgresql.org; Thu, 10 Apr 2025 08:04:25 +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.94.2) (envelope-from ) id 1u2mrA-009gui-Se for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:01:53 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u2mr7-0041Oh-2C for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:01:52 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=L80zqDNL7wotL5j6BhGf7OTka/+Mhn7rp73arlUAcwM=; b=MD3pd4p14uEGTYhBEDv2O4dQl9 LN+snflxKONfq3PmNQMiZ4pdK/t+ug8Wx4m9joFEqfiwJEk7MUY6B5foNyPLQ2mT0vN+wQSXVlnQW HTsh5G93YBORspDe5O0ZJsrNkzFXQLhYpEwh07YKWI25JtiUp/xaqmts0BJgjCkoPJddq4fC63NDS PzKAIznGXDKbTVp98Ht0F0he0X6Y2MAvp0f14u70p05YZjVe9l2Cs1AvJJ52mRfp2WtYkQA3JC7CW 0inV+2SQXUpjg1YxPF/qOhZnQ6wO11QokOEG9NTVMgZ4q2rg0W2Wk3FTqAYqAbnv6on0rk/qG8qrs LbQPsoLg==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u2mr6-002rlM-M7 for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:01:48 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1u2mr5-003ZBD-1o for pgsql-committers@lists.postgresql.org; Thu, 10 Apr 2025 08:01:47 +0000 Content-Type: multipart/mixed; boundary="===============2191410627613771434==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix data loss in logical replication. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 10 Apr 2025 08:01:47 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2191410627613771434== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGRhdGEgbG9zcyBpbiBsb2dpY2FsIHJlcGxpY2F0aW9uLgoKRGF0YSBsb3NzIGNhbiBoYXBw ZW4gd2hlbiB0aGUgRERMcyBsaWtlIEFMVEVSIFBVQkxJQ0FUSU9OIC4uLiBBREQgVEFCTEUgLi4u Cm9yIEFMVEVSIFRZUEUgLi4uICB0aGF0IGRvbid0IHRha2UgYSBzdHJvbmcgbG9jayBvbiB0YWJs ZSBoYXBwZW5zCmNvbmN1cnJlbnRseSB0byBETUxzIG9uIHRoZSB0YWJsZXMgaW52b2x2ZWQgaW4g dGhlIERETC4gVGhpcyBoYXBwZW5zCmJlY2F1c2UgbG9naWNhbCBkZWNvZGluZyBkb2Vzbid0IGRp c3RyaWJ1dGUgaW52YWxpZGF0aW9ucyB0byBjb25jdXJyZW50CnRyYW5zYWN0aW9ucyBhbmQgdGhv c2UgdHJhbnNhY3Rpb25zIHVzZSBzdGFsZSBjYWNoZSBkYXRhIHRvIGRlY29kZSB0aGUKY2hhbmdl cy4gVGhlIHByb2JsZW0gYmVjb21lcyBiaWdnZXIgYmVjYXVzZSB3ZSBrZWVwIHVzaW5nIHRoZSBz dGFsZSBjYWNoZQpldmVuIGFmdGVyIHRob3NlIGluLXByb2dyZXNzIHRyYW5zYWN0aW9ucyBhcmUg ZmluaXNoZWQgYW5kIHNraXAgdGhlCmNoYW5nZXMgcmVxdWlyZWQgdG8gYmUgc2VudCB0byB0aGUg Y2xpZW50LgoKVGhpcyBjb21taXQgZml4ZXMgdGhlIGlzc3VlIGJ5IGRpc3RyaWJ1dGluZyBpbnZh bGlkYXRpb24gbWVzc2FnZXMgZnJvbQpjYXRhbG9nLW1vZGlmeWluZyB0cmFuc2FjdGlvbnMgdG8g YWxsIGNvbmN1cnJlbnQgaW4tcHJvZ3Jlc3MgdHJhbnNhY3Rpb25zLgpUaGlzIGFsbG93cyB0aGUg bmVjZXNzYXJ5IHJlYnVpbGQgb2YgdGhlIGNhdGFsb2cgY2FjaGUgd2hlbiBkZWNvZGluZyBuZXcK Y2hhbmdlcyBhZnRlciBjb25jdXJyZW50IERETC4KCldlIG9ic2VydmVkIHBlcmZvcm1hbmNlIHJl Z3Jlc3Npb24gcHJpbWFyaWx5IGR1cmluZyBmcmVxdWVudCBleGVjdXRpb24gb2YKKnB1YmxpY2F0 aW9uIERETCogc3RhdGVtZW50cyB0aGF0IG1vZGlmeSB0aGUgcHVibGlzaGVkIHRhYmxlcy4gVGhl CnJlZ3Jlc3Npb24gaXMgbWlub3Igb3IgbmVhcmx5IG5vbmV4aXN0ZW50IGZvciBERExzIHRoYXQg ZG8gbm90IGFmZmVjdCB0aGUKcHVibGlzaGVkIHRhYmxlcyBvciBvY2N1ciBpbmZyZXF1ZW50bHks IG1ha2luZyB0aGlzIGEgd29ydGh3aGlsZSBjb3N0IHRvCnJlc29sdmUgYSBsb25nc3RhbmRpbmcg ZGF0YSBsb3NzIGlzc3VlLgoKQW4gYWx0ZXJuYXRpdmUgYXBwcm9hY2ggY29uc2lkZXJlZCB3YXMg dG8gdGFrZSBhIHN0cm9uZyBsb2NrIG9uIGVhY2gKYWZmZWN0ZWQgdGFibGUgZHVyaW5nIHB1Ymxp Y2F0aW9uIG1vZGlmaWNhdGlvbi4gSG93ZXZlciwgdGhpcyB3b3VsZCBvbmx5CmFkZHJlc3MgaXNz dWVzIHJlbGF0ZWQgdG8gcHVibGljYXRpb24gRERMcyAoYnV0IG5vdCB0aGUgQUxURVIgVFlQRSAu Li4pCmFuZCByZXF1aXJlIGxvY2tpbmcgZXZlcnkgcmVsYXRpb24gaW4gdGhlIGRhdGFiYXNlIGZv ciBwdWJsaWNhdGlvbnMKY3JlYXRlZCBhcyBGT1IgQUxMIFRBQkxFUywgd2hpY2ggaXMgaW1wcmFj dGljYWwuCgpUaGUgYnVnIGV4aXN0cyBpbiBhbGwgc3VwcG9ydGVkIGJyYW5jaGVzLCBidXQgd2Ug YXJlIGJhY2twYXRjaGluZyB0aWxsIDE0LgpUaGUgZml4IGZvciAxMyByZXF1aXJlcyBzb21ld2hh dCBiaWdnZXIgY2hhbmdlcyB0aGFuIHRoaXMgZml4LCBzbyB0aGUgZml4CmZvciB0aGF0IGJyYW5j aCBpcyBzdGlsbCB1bmRlciBkaXNjdXNzaW9uLgoKUmVwb3J0ZWQtYnk6IGh1YmVydCBkZXBlc3og bHViYWN6ZXdza2kgPGRlcGVzekBkZXBlc3ouY29tPgpSZXBvcnRlZC1ieTogVG9tYXMgVm9uZHJh IDx0b21hcy52b25kcmFAZW50ZXJwcmlzZWRiLmNvbT4KQXV0aG9yOiBTaGxvayBLeWFsIDxzaGxv ay5reWFsLm9zc0BnbWFpbC5jb20+CkF1dGhvcjogSGF5YXRvIEt1cm9kYSA8a3Vyb2RhLmhheWF0 b0BmdWppdHN1LmNvbT4KUmV2aWV3ZWQtYnk6IFpoaWppZSBIb3UgPGhvdXpqLmZuc3RAZnVqaXRz dS5jb20+ClJldmlld2VkLWJ5OiBNYXNhaGlrbyBTYXdhZGEgPHNhd2FkYS5tc2hrQGdtYWlsLmNv bT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0LmthcGlsYTE2QGdtYWlsLmNvbT4KVGVz dGVkLWJ5OiBCZW5vaXQgTG9icsOpYXUgPGJlbm9pdC5sb2JyZWF1QGRhbGliby5jb20+CkJhY2tw YXRjaC10aHJvdWdoOiAxNApEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL2RlNTJiMjgy LTExNjYtMTE4MC00NWEyLThkODkxN2NhNzRjNkBlbnRlcnByaXNlZGIuY29tCkRpc2N1c3Npb246 IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FEMjFBb0FlblZxaU1qcE4tUHZHSEwxTjlEV25IU3E2NzNi ZmdyNnBobUJVeng9a0xRQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tClJFTF8xNl9TVEFC TEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRk aWZmLzlhMmY4YjRmMDFkNWE0MGI4YjA4MGY2YjEwOGFlMzE0YTY3MzBjZWMKCk1vZGlmaWVkIEZp bGVzCi0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvdGVzdF9kZWNvZGluZy9NYWtlZmlsZSAgICAgICAg ICAgICAgICAgICAgIHwgIDIgKy0KLi4uL2V4cGVjdGVkL2ludmFsaWRhdGlvbl9kaXN0cnVidXRp b24ub3V0ICAgICAgICAgfCAyMCArKysrKysrCmNvbnRyaWIvdGVzdF9kZWNvZGluZy9tZXNvbi5i dWlsZCAgICAgICAgICAgICAgICAgIHwgIDEgKwouLi4vc3BlY3MvaW52YWxpZGF0aW9uX2Rpc3Ry dWJ1dGlvbi5zcGVjICAgICAgICAgICB8IDMyICsrKysrKysrKysrCnNyYy9iYWNrZW5kL3JlcGxp Y2F0aW9uL2xvZ2ljYWwvcmVvcmRlcmJ1ZmZlci5jICAgIHwgMjMgKysrKysrKysKc3JjL2JhY2tl bmQvcmVwbGljYXRpb24vbG9naWNhbC9zbmFwYnVpbGQuYyAgICAgICAgfCA2NyArKysrKysrKysr KysrKysrKy0tLS0tCnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9uL3Jlb3JkZXJidWZmZXIuaCAgICAg ICAgICAgIHwgIDQgKysKNyBmaWxlcyBjaGFuZ2VkLCAxMzQgaW5zZXJ0aW9ucygrKSwgMTUgZGVs ZXRpb25zKC0pCgo= --===============2191410627613771434==--