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 1vGWpk-00HCU1-03 for pgsql-committers@arkaria.postgresql.org; Wed, 05 Nov 2025 06:17: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 1vGWph-000a8e-FD for pgsql-committers@arkaria.postgresql.org; Wed, 05 Nov 2025 06:17:24 +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 1vGWph-000a8L-63 for pgsql-committers@lists.postgresql.org; Wed, 05 Nov 2025 06:17:24 +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 1vGWpe-005X8V-1s for pgsql-committers@lists.postgresql.org; Wed, 05 Nov 2025 06:17:23 +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=s/iBJkg3ws0i4RJtNhog33+kEeD5FhD5fiYjreSS4O4=; b=gTt0rP/Ei/jFjlhnAdGm5WgG7Y y/970nuhYl/U/gfOGdZlQIwHHO/FVYGEoOqn7DwamEiRALgp1ESxAynzP3L/jNFy+cMztLxcepjFM qRPvdtAJxwPj2HX/JD78LlSiR9ZutuSp1WC/+icFmeD3OC6pYmHj+HC3YShUNSJvTNa88e9e9OHPP awTNuR3Re/zi8yUWflBfjuynkC5lq0o6I/IUtMeFutSqcOe6UtoUnk4uGQPVg91F/KPK3RyQoEqeA 7auY6LR1ZshGCZiVm7zh8ynM7a440v+U6TkI0eOLbAf+64x3/sZ84JQGOnRQzuB6kET8GELbqwl9/ G2wUSF/A==; 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 1vGWpe-00A6vJ-S9 for pgsql-committers@lists.postgresql.org; Wed, 05 Nov 2025 06:17:21 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vGWpc-0056sd-1s for pgsql-committers@lists.postgresql.org; Wed, 05 Nov 2025 06:17:20 +0000 Content-Type: multipart/mixed; boundary="===============4690947353329302276==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Add sequence synchronization for logical replication. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 05 Nov 2025 06:17:20 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4690947353329302276== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWRkIHNlcXVlbmNlIHN5bmNocm9uaXphdGlvbiBmb3IgbG9naWNhbCByZXBsaWNhdGlvbi4KClRo aXMgcGF0Y2ggaW50cm9kdWNlcyBzZXF1ZW5jZSBzeW5jaHJvbml6YXRpb24uIFNlcXVlbmNlcyB0 aGF0IGFyZSBzeW5jZWQKd2lsbCBoYXZlIDIgc3RhdGVzOgogICAtIElOSVQgKG5lZWRzIFtyZV1z eW5jaHJvbml6aW5nKQogICAtIFJFQURZIChpcyBhbHJlYWR5IHN5bmNocm9uaXplZCkKCkEgbmV3 IHNlcXVlbmNlc3luYyB3b3JrZXIgaXMgbGF1bmNoZWQgYXMgbmVlZGVkIHRvIHN5bmNocm9uaXpl IHNlcXVlbmNlcy4KQSBzaW5nbGUgc2VxdWVuY2VzeW5jIHdvcmtlciBpcyByZXNwb25zaWJsZSBm b3Igc3luY2hyb25pemluZyBhbGwKc2VxdWVuY2VzLiBJdCBiZWdpbnMgYnkgcmV0cmlldmluZyB0 aGUgbGlzdCBvZiBzZXF1ZW5jZXMgdGhhdCBhcmUgZmxhZ2dlZApmb3Igc3luY2hyb25pemF0aW9u LCBpLmUuLCB0aG9zZSBpbiB0aGUgSU5JVCBzdGF0ZS4gVGhlc2Ugc2VxdWVuY2VzIGFyZQp0aGVu IHByb2Nlc3NlZCBpbiBiYXRjaGVzLCBhbGxvd2luZyBtdWx0aXBsZSBlbnRyaWVzIHRvIGJlIHN5 bmNocm9uaXplZAp3aXRoaW4gYSBzaW5nbGUgdHJhbnNhY3Rpb24uIFRoZSB3b3JrZXIgZmV0Y2hl cyB0aGUgY3VycmVudCBzZXF1ZW5jZQp2YWx1ZXMgYW5kIHBhZ2UgTFNOcyBmcm9tIHRoZSByZW1v dGUgcHVibGlzaGVyLCB1cGRhdGVzIHRoZSBjb3JyZXNwb25kaW5nCnNlcXVlbmNlcyBvbiB0aGUg bG9jYWwgc3Vic2NyaWJlciwgYW5kIGZpbmFsbHkgbWFya3MgZWFjaCBzZXF1ZW5jZSBhcwpSRUFE WSB1cG9uIHN1Y2Nlc3NmdWwgc3luY2hyb25pemF0aW9uLgoKU2VxdWVuY2Ugc3luY2hyb25pemF0 aW9uIG9jY3VycyBpbiAzIHBsYWNlczoKMSkgQ1JFQVRFIFNVQlNDUklQVElPTgogICAgLSBUaGUg Y29tbWFuZCBzeW50YXggcmVtYWlucyB1bmNoYW5nZWQuCiAgICAtIFRoZSBzdWJzY3JpYmVyIHJl dHJpZXZlcyBzZXF1ZW5jZXMgYXNzb2NpYXRlZCB3aXRoIHB1YmxpY2F0aW9ucy4KICAgIC0gUHVi bGlzaGVkIHNlcXVlbmNlcyBhcmUgYWRkZWQgdG8gcGdfc3Vic2NyaXB0aW9uX3JlbCB3aXRoIElO SVQKICAgICAgc3RhdGUuCiAgICAtIEluaXRpYXRlIHRoZSBzZXF1ZW5jZXN5bmMgd29ya2VyIHRv IHN5bmNocm9uaXplIGFsbCBzZXF1ZW5jZXMuCgoyKSBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIFJF RlJFU0ggUFVCTElDQVRJT04KICAgIC0gVGhlIGNvbW1hbmQgc3ludGF4IHJlbWFpbnMgdW5jaGFu Z2VkLgogICAgLSBEcm9wcGVkIHB1Ymxpc2hlZCBzZXF1ZW5jZXMgYXJlIHJlbW92ZWQgZnJvbSBw Z19zdWJzY3JpcHRpb25fcmVsLgogICAgLSBOZXdseSBwdWJsaXNoZWQgc2VxdWVuY2VzIGFyZSBh ZGRlZCB0byBwZ19zdWJzY3JpcHRpb25fcmVsIHdpdGggSU5JVAogICAgICBzdGF0ZS4KICAgIC0g SW5pdGlhdGUgdGhlIHNlcXVlbmNlc3luYyB3b3JrZXIgdG8gc3luY2hyb25pemUgb25seSBuZXds eSBhZGRlZAogICAgICBzZXF1ZW5jZXMuCgozKSBBTFRFUiBTVUJTQ1JJUFRJT04gLi4uIFJFRlJF U0ggU0VRVUVOQ0VTCiAgICAtIEEgbmV3IGNvbW1hbmQgaW50cm9kdWNlZCBmb3IgUEcxOSBieSBm MGIzNTczYzNhLgogICAgLSBBbGwgc2VxdWVuY2VzIGluIHBnX3N1YnNjcmlwdGlvbl9yZWwgYXJl IHJlc2V0IHRvIElOSVQgc3RhdGUuCiAgICAtIEluaXRpYXRlIHRoZSBzZXF1ZW5jZXN5bmMgd29y a2VyIHRvIHN5bmNocm9uaXplIGFsbCBzZXF1ZW5jZXMuCiAgICAtIFVubGlrZSAiQUxURVIgU1VC U0NSSVBUSU9OIC4uLiBSRUZSRVNIIFBVQkxJQ0FUSU9OIiBjb21tYW5kLAogICAgICBhZGRpdGlv biBhbmQgcmVtb3ZhbCBvZiBtaXNzaW5nIHNlcXVlbmNlcyB3aWxsIG5vdCBiZSBkb25lIGluIHRo aXMKICAgICAgY2FzZS4KCkF1dGhvcjogVmlnbmVzaCBDIDx2aWduZXNoMjFAZ21haWwuY29tPgpS ZXZpZXdlZC1ieTogc2h2ZXRhIG1hbGlrIDxzaHZldGEubWFsaWtAZ21haWwuY29tPgpSZXZpZXdl ZC1ieTogSG91IFpoaWppZSA8aG91emouZm5zdEBmdWppdHN1LmNvbT4KUmV2aWV3ZWQtYnk6IE1h c2FoaWtvIFNhd2FkYSA8c2F3YWRhLm1zaGtAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSGF5YXRv IEt1cm9kYSA8a3Vyb2RhLmhheWF0b0BmdWppdHN1LmNvbT4KUmV2aWV3ZWQtYnk6IERpbGlwIEt1 bWFyIDxkaWxpcGJhbGF1dEBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBQZXRlciBTbWl0aCA8c21p dGhwYjIyNTBAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogTmlzaGEgTW9vbmQgPG5pc2hhLm1vb25k NDEyQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFNobG9rIEt5YWwgPHNobG9rLmt5YWwub3NzQGdt YWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0LmthcGlsYTE2QGdtYWlsLmNv bT4KUmV2aWV3ZWQtYnk6IENoYW8gTGkgPGxpLmV2YW4uY2hhb0BnbWFpbC5jb20+CkRpc2N1c3Np b246IGh0dHBzOi8vcG9zdGdyLmVzL20vQ0FBNGVLMUxDK0tKaUFrU3JwRV9Od3ZOZGlkdzlGMm9z N0dFUlVlU3hTS3Y3MWdYeXNRQG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoK RGV0YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYv NTUwOTA1NWQ2OTU2NzQ1NTMyZTY1YWIyMThlMTViOTlkODdkNjZjZQoKTW9kaWZpZWQgRmlsZXMK LS0tLS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvY2F0YWxvZy9wZ19zdWJzY3JpcHRpb24uYyAgICAg ICAgICB8ICAgMiArLQpzcmMvYmFja2VuZC9jb21tYW5kcy9zZXF1ZW5jZS5jICAgICAgICAgICAg ICAgIHwgIDE4ICstCnNyYy9iYWNrZW5kL3Bvc3RtYXN0ZXIvYmd3b3JrZXIuYyAgICAgICAgICAg ICAgfCAgIDUgKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9NYWtlZmlsZSAgICAg ICB8ICAgMSArCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvbGF1bmNoZXIuYyAgICAg fCAgNTcgKy0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vbG9naWNhbC9tZXNvbi5idWlsZCAgICB8 ICAgMSArCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xvZ2ljYWwvc2VxdWVuY2VzeW5jLmMgfCA3 NDUgKysrKysrKysrKysrKysrKysrKysrKysrKwpzcmMvYmFja2VuZC9yZXBsaWNhdGlvbi9sb2dp Y2FsL3N5bmN1dGlscy5jICAgIHwgMTM5ICsrKystCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xv Z2ljYWwvdGFibGVzeW5jLmMgICAgfCAgNzcgKy0tCnNyYy9iYWNrZW5kL3JlcGxpY2F0aW9uL2xv Z2ljYWwvd29ya2VyLmMgICAgICAgfCAgNzYgKystCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvZ3Vj X3BhcmFtZXRlcnMuZGF0ICAgICAgfCAgIDIgKy0Kc3JjL2luY2x1ZGUvY2F0YWxvZy9jYXR2ZXJz aW9uLmggICAgICAgICAgICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9jYXRhbG9nL3BnX3Byb2Mu ZGF0ICAgICAgICAgICAgICAgIHwgICAyICstCnNyYy9pbmNsdWRlL2NhdGFsb2cvcGdfc3Vic2Ny aXB0aW9uX3JlbC5oICAgICAgfCAgMjMgKwpzcmMvaW5jbHVkZS9jb21tYW5kcy9zZXF1ZW5jZS5o ICAgICAgICAgICAgICAgIHwgICAxICsKc3JjL2luY2x1ZGUvcmVwbGljYXRpb24vbG9naWNhbHdv cmtlci5oICAgICAgICB8ICAgMyArLQpzcmMvaW5jbHVkZS9yZXBsaWNhdGlvbi93b3JrZXJfaW50 ZXJuYWwuaCAgICAgIHwgIDIyICstCnNyYy90ZXN0L3N1YnNjcmlwdGlvbi90LzAzNl9zZXF1ZW5j ZXMucGwgICAgICAgfCAxNzcgKysrKystCnNyYy90b29scy9wZ2luZGVudC90eXBlZGVmcy5saXN0 ICAgICAgICAgICAgICAgfCAgIDIgKwoxOSBmaWxlcyBjaGFuZ2VkLCAxMjI5IGluc2VydGlvbnMo KyksIDEyNiBkZWxldGlvbnMoLSkKCg== --===============4690947353329302276==--