Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nB2vq-000130-JU for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jan 2022 23:02:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nB2vo-0003gB-Te for pgsql-hackers@arkaria.postgresql.org; Fri, 21 Jan 2022 23:02:56 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nB2vo-0003g2-GE for pgsql-hackers@lists.postgresql.org; Fri, 21 Jan 2022 23:02:56 +0000 Received: from smtp-fw-6001.amazon.com ([52.95.48.154]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nB2vl-0005zm-Ic for pgsql-hackers@postgresql.org; Fri, 21 Jan 2022 23:02:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1642806173; x=1674342173; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=VtFbhQI3ww9xagvd7088QSVuoFuewb4gDpMvUJTVHRA=; b=txB8AIXANQlxOW5+LMUeuKvIiFnaLtYHWSqy/AlaHkqnYULoanzvb8Wy 5KwV8iBD9xNR1I+5bGjRz+vxqbSh327bxkZgfhswn/PYI50zBCUaKTgPF EkAf9ZxRlRnvlr+feiizk79IePhrSAl7abawInINgqVxB5TB8spGbHwn5 4=; X-IronPort-AV: E=Sophos;i="5.88,306,1635206400"; d="scan'208";a="172331714" Subject: Re: Synchronizing slots from primary to standby Thread-Topic: Synchronizing slots from primary to standby Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO email-inbound-relay-pdx-2c-7d0c7241.us-west-2.amazon.com) ([10.43.8.6]) by smtp-border-fw-6001.iad6.amazon.com with ESMTP; 21 Jan 2022 23:02:51 +0000 Received: from EX13MTAUWB001.ant.amazon.com (pdx1-ws-svc-p6-lb9-vlan3.pdx.amazon.com [10.236.137.198]) by email-inbound-relay-pdx-2c-7d0c7241.us-west-2.amazon.com (Postfix) with ESMTPS id BE5F341915; Fri, 21 Jan 2022 23:02:50 +0000 (UTC) Received: from EX13D11UWC004.ant.amazon.com (10.43.162.101) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Fri, 21 Jan 2022 23:02:50 +0000 Received: from EX13D11UWC004.ant.amazon.com (10.43.162.101) by EX13D11UWC004.ant.amazon.com (10.43.162.101) with Microsoft SMTP Server (TLS) id 15.0.1497.28; Fri, 21 Jan 2022 23:02:50 +0000 Received: from EX13D11UWC004.ant.amazon.com ([10.43.162.101]) by EX13D11UWC004.ant.amazon.com ([10.43.162.101]) with mapi id 15.00.1497.028; Fri, 21 Jan 2022 23:02:50 +0000 From: "Hsu, John" To: Masahiko Sawada , Peter Eisentraut CC: pgsql-hackers Thread-Index: AQHXzj+PGAwAyWbkU0uP+11wRgdchqwy0vAAgDqhTYCAAJ8sgA== Date: Fri, 21 Jan 2022 23:02:50 +0000 Message-ID: References: <514f6f2f-6833-4539-39f1-96cd1e011f23@enterprisedb.com> <18dbc929-a281-8552-4f1d-7e4d0e4eedba@enterprisedb.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.43.161.126] Content-Type: text/plain; charset="utf-8" Content-ID: <26E8A33B5CCA9346BA82DC4204D5CBAC@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ICAgPiBJIG1pZ2h0IGJlIG1pc3Npbmcgc29tZXRoaW5nIGJ1dCBpc27igJl0IGl0IG9rYXkgZXZl biBpZiB0aGUgbmV3IHByaW1hcnkNCiAgID4gc2VydmVyIGlzIGJlaGluZCB0aGUgc3Vic2NyaWJl cnM/IElPVywgZXZlbiBpZiB0d28gc2xvdCdzIExTTnMgKGkuZS4sDQogICA+IHJlc3RhcnRfbHNu IGFuZCBjb25maXJtX2ZsdXNoX2xzbikgYXJlIGJlaGluZCB0aGUgc3Vic2NyaWJlcidzIHJlbW90 ZQ0KICAgPiBMU04gKGkuZS4sIHBnX3JlcGxpY2F0aW9uX29yaWdpbi5yZW1vdGVfbHNuKSwgdGhl IHByaW1hcnkgc2VuZHMgb25seQ0KICAgPiB0cmFuc2FjdGlvbnMgdGhhdCB3ZXJlIGNvbW1pdHRl ZCBhZnRlciB0aGUgcmVtb3RlX2xzbi4gU28gdGhlDQogICA+IHN1YnNjcmliZXIgY2FuIHJlc3Vt ZSBsb2dpY2FsIHJlcGxpY2F0aW9uIHdpdGggdGhlIG5ldyBwcmltYXJ5IHdpdGhvdXQNCiAgID4g YW55IGRhdGEgbG9zcy4NCg0KICAgIE1heWJlIEknbSBtaXNyZWFkaW5nLCBidXQgSSB0aG91Z2h0 IHRoZSBwdXJwb3NlIG9mIHRoaXMgdG8gbWFrZSANCiAgICBzdXJlIHRoYXQgdGhlIGxvZ2ljYWwg c3Vic2NyaWJlciBkb2VzIG5vdCBoYXZlIGRhdGEgdGhhdCBoYXMgbm90IGJlZW4NCiAgICByZXBs aWNhdGVkIHRvIHRoZSBuZXcgcHJpbWFyeS4gVGhlIHVzZS1jYXNlIEkgY2FuIHRoaW5rIG9mIHdv dWxkIGJlDQogICAgaWYgc3luY2hyb25vdXNfY29tbWl0IHdlcmUgZW5hYmxlZCBhbmQgZmFpbC1v dmVyIG9jY3Vycy4gSWYNCiAgICB3ZSBkaWRuJ3QgaGF2ZSB0aGlzIHNldCwgaXNuJ3QgaXQgcG9z c2libGUgdGhhdCB0aGlzIGxvZ2ljYWwgc3Vic2NyaWJlcg0KICAgIGhhcyBleHRyYSBjb21taXRz IHRoYXQgYXJlbid0IHByZXNlbnQgb24gdGhlIG5ld2x5IHByb21vdGVkIHByaW1hcnk/DQoNCiAg ICBBbmQgc29ycnkgSSBhY2NpZGVudGFsbHkgc3RhcnRlZCBhIG5ldyB0aHJlYWQgaW4gbXkgbGFz dCByZXBseS4gDQogICAgUmUtcGFzdGluZyBzb21lIG9mIG15IHByZXZpb3VzIHF1ZXN0aW9ucy9j b21tZW50czoNCg0KICAgIHdhaXRfZm9yX3N0YW5kYnlfY29uZmlybWF0aW9uIGRvZXMgbm90IHVw ZGF0ZSBzdGFuZGJ5X3Nsb3RfbmFtZXMgb25jZSBpdCdzDQogICAgaW4gYSBsb29wIGFuZCBjYW4n dCBiZSBmaXhlZCB3aXRoIFNJR0hVUC4gU2ltaWxhcmx5LCBzeW5jaHJvbml6ZV9zbG90X25hbWVz IA0KICAgIGlzbid0IHVwZGF0ZWQgb25jZSB0aGUgd29ya2VyIGlzIGxhdW5jaGVkLg0KDQogICAg SWYgYSBsb2dpY2FsIHNsb3Qgd2FzIGRyb3BwZWQgb24gdGhlIHdyaXRlciwgc2hvdWxkIHRoZSB3 b3JrZXIgZHJvcCBsb2dpY2FsIA0KICAgIHNsb3RzIHRoYXQgaXQgd2FzIHByZXZpb3VzbHkgc3lu Y2hyb25pemluZyBidXQgYXJlIG5vIGxvbmdlciBwcmVzZW50PyBPciANCiAgICBzaG91bGQgd2Ug bGVhdmUgdGhhdCB0byB0aGUgdXNlciB0byBtYW5hZ2U/IEknbSB0cnlpbmcgdG8gdGhpbmsgd2h5 IHVzZXJzIA0KICAgIHdvdWxkIHdhbnQgdG8gc3luYyBsb2dpY2FsIHNsb3RzIHRvIGEgcmVhZGVy IGJ1dCBub3QgaGF2ZSB0aGF0IGJlIGRyb3BwZWQgDQogICAgYXMgd2VsbCBpZiBpdCdzIG5vIGxv bmdlciBwcmVzZW50Lg0KDQogICAgSXMgdGhlcmUgYSByZWFzb24gd2UncmUgZGVjaWRpbmcgdG8g dXNlIG9uZS13b3JrZXIgc3luY2luZyBwZXIgZGF0YWJhc2UgDQogICAgaW5zdGVhZCBvZiBvbmUg Z2VuZXJhbCB3b3JrZXIgdGhhdCBzeW5jcyBhY3Jvc3MgYWxsIHRoZSBkYXRhYmFzZXM/IA0KICAg IEkgaW1hZ2luZSBJJ20gbWlzc2luZyBzb21ldGhpbmcgb2J2aW91cyBoZXJlLiANCg0KICAgIEFz IGZvciBob3cgc3RhbmRieV9zbG90X25hbWVzIHNob3VsZCBiZSBjb25maWd1cmVkLCBJJ2QgcHJl ZmVyIHRoZSANCiAgICBmbGV4aWJpbGl0eSBzaW1pbGFyIHRvIHdoYXQgd2UgaGF2ZSBmb3Igc3lu Y2hyb251c19zdGFuZGJ5X25hbWVzIHNpbmNlIA0KICAgIHRoYXQgc2VlbXMgdGhlIG1vc3QgYW5h bG9nb3VzLiBJdCdkIHByb3ZpZGUgZmxleGliaWxpdHkgZm9yIGZhaWxvdmVycywgDQogICAgd2hp Y2ggSSBpbWFnaW5lIGlzIHRoZSBtb3N0IGNvbW1vbiB1c2UtY2FzZS4NCg0K77u/T24gMS8yMC8y MiwgOTozNCBQTSwgIk1hc2FoaWtvIFNhd2FkYSIgPHNhd2FkYS5tc2hrQGdtYWlsLmNvbT4gd3Jv dGU6DQoNCiAgICBDQVVUSU9OOiBUaGlzIGVtYWlsIG9yaWdpbmF0ZWQgZnJvbSBvdXRzaWRlIG9m IHRoZSBvcmdhbml6YXRpb24uIERvIG5vdCBjbGljayBsaW5rcyBvciBvcGVuIGF0dGFjaG1lbnRz IHVubGVzcyB5b3UgY2FuIGNvbmZpcm0gdGhlIHNlbmRlciBhbmQga25vdyB0aGUgY29udGVudCBp cyBzYWZlLg0KDQoNCg0KICAgIE9uIFdlZCwgRGVjIDE1LCAyMDIxIGF0IDc6MTMgQU0gUGV0ZXIg RWlzZW50cmF1dA0KICAgIDxwZXRlci5laXNlbnRyYXV0QGVudGVycHJpc2VkYi5jb20+IHdyb3Rl Og0KICAgID4NCiAgICA+IE9uIDMxLjEwLjIxIDExOjA4LCBQZXRlciBFaXNlbnRyYXV0IHdyb3Rl Og0KICAgID4gPiBJIHdhbnQgdG8gcmVhY3RpdmF0ZSAkc3ViamVjdC4gIEkgdG9vayBQZXRyIEpl bGluZWsncyBwYXRjaCBmcm9tIFswXSwNCiAgICA+ID4gcmViYXNlZCBpdCwgYWRkZWQgYSBiaXQg b2YgdGVzdGluZy4gIEl0IGJhc2ljYWxseSB3b3JrcywgYnV0IGFzDQogICAgPiA+IG1lbnRpb25l ZCBpbiBbMF0sIHRoZXJlIGFyZSB2YXJpb3VzIGlzc3VlcyB0byB3b3JrIG91dC4NCiAgICA+ID4N CiAgICA+ID4gVGhlIGlkZWEgaXMgdGhhdCB0aGUgc3RhbmRieSBydW5zIGEgYmFja2dyb3VuZCB3 b3JrZXIgdG8gcGVyaW9kaWNhbGx5DQogICAgPiA+IGZldGNoIHJlcGxpY2F0aW9uIHNsb3QgaW5m b3JtYXRpb24gZnJvbSB0aGUgcHJpbWFyeS4gIE9uIGZhaWxvdmVyLCBhDQogICAgPiA+IGxvZ2lj YWwgc3Vic2NyaWJlciB3b3VsZCB0aGVuIGlkZWFsbHkgZmluZCB1cC10by1kYXRlIHJlcGxpY2F0 aW9uIHNsb3RzDQogICAgPiA+IG9uIHRoZSBuZXcgcHVibGlzaGVyIGFuZCBjYW4ganVzdCBjb250 aW51ZSBub3JtYWxseS4NCiAgICA+DQogICAgPiA+IFNvLCBhZ2FpbiwgdGhpcyBpc24ndCBhbnl3 aGVyZSBuZWFyIHJlYWR5LCBidXQgdGhlcmUgaXMgYWxyZWFkeSBhIGxvdA0KICAgID4gPiBoZXJl IHRvIGdhdGhlciBmZWVkYmFjayBhYm91dCBob3cgaXQgd29ya3MsIGhvdyBpdCBzaG91bGQgd29y aywgaG93IHRvDQogICAgPiA+IGNvbmZpZ3VyZSBpdCwgYW5kIGhvdyBpdCBmaXRzIGludG8gYW4g b3ZlcmFsbCByZXBsaWNhdGlvbiBhbmQgSEENCiAgICA+ID4gYXJjaGl0ZWN0dXJlLg0KICAgID4N CiAgICA+IFRoZSBzZWNvbmQsDQogICAgPiBzdGFuZGJ5X3Nsb3RfbmFtZXMsIGlzIHNldCBvbiB0 aGUgcHJpbWFyeS4gIEl0IGhvbGRzIGJhY2sgbG9naWNhbA0KICAgID4gcmVwbGljYXRpb24gdW50 aWwgdGhlIGxpc3RlZCBwaHlzaWNhbCBzdGFuZGJ5cyBoYXZlIGNhdWdodCB1cC4gIFRoYXQNCiAg ICA+IHdheSwgd2hlbiBmYWlsb3ZlciBpcyBuZWNlc3NhcnksIHRoZSBwcm9tb3RlZCBzdGFuZGJ5 IGlzIG5vdCBiZWhpbmQgdGhlDQogICAgPiBsb2dpY2FsIHJlcGxpY2F0aW9uIGNvbnN1bWVycy4N Cg0KICAgIEkgbWlnaHQgYmUgbWlzc2luZyBzb21ldGhpbmcgYnV0IGlzbuKAmXQgaXQgb2theSBl dmVuIGlmIHRoZSBuZXcgcHJpbWFyeQ0KICAgIHNlcnZlciBpcyBiZWhpbmQgdGhlIHN1YnNjcmli ZXJzPyBJT1csIGV2ZW4gaWYgdHdvIHNsb3QncyBMU05zIChpLmUuLA0KICAgIHJlc3RhcnRfbHNu IGFuZCBjb25maXJtX2ZsdXNoX2xzbikgYXJlIGJlaGluZCB0aGUgc3Vic2NyaWJlcidzIHJlbW90 ZQ0KICAgIExTTiAoaS5lLiwgcGdfcmVwbGljYXRpb25fb3JpZ2luLnJlbW90ZV9sc24pLCB0aGUg cHJpbWFyeSBzZW5kcyBvbmx5DQogICAgdHJhbnNhY3Rpb25zIHRoYXQgd2VyZSBjb21taXR0ZWQg YWZ0ZXIgdGhlIHJlbW90ZV9sc24uIFNvIHRoZQ0KICAgIHN1YnNjcmliZXIgY2FuIHJlc3VtZSBs b2dpY2FsIHJlcGxpY2F0aW9uIHdpdGggdGhlIG5ldyBwcmltYXJ5IHdpdGhvdXQNCiAgICBhbnkg ZGF0YSBsb3NzLg0KDQogICAgVGhlIG5ldyBwcmltYXJ5IHNob3VsZCBub3QgYmUgYWhlYWQgb2Yg dGhlIHN1YnNjcmliZXJzIGJlY2F1c2UgaXQNCiAgICBmb3J3YXJkcyB0aGUgbG9naWNhbCByZXBs aWNhdGlvbiBzdGFydCBMU04gdG8gdGhlIHNsb3TigJlzDQogICAgY29uZmlybV9mbHVzaF9sc24g aW4gdGhpcyBjYXNlLiBCdXQgaXQgY2Fubm90IGhhcHBlbiBzaW5jZSB0aGUgcmVtb3RlDQogICAg TFNOIG9mIHRoZSBzdWJzY3JpYmVy4oCZcyBvcmlnaW4gaXMgYWx3YXlzIHVwZGF0ZWQgZmlyc3Qs IHRoZW4gdGhlDQogICAgY29uZmlybV9mbHVzaF9sc24gb2YgdGhlIHNsb3Qgb24gdGhlIHByaW1h cnkgaXMgdXBkYXRlZCwgYW5kIHRoZW4gdGhlDQogICAgY29uZmlybV9mbHVzaF9sc24gb2YgdGhl IHNsb3Qgb24gdGhlIHN0YW5kYnkgaXMgc3luY2hyb25pemVkLg0KDQogICAgUmVnYXJkcywNCg0K ICAgIC0tDQogICAgTWFzYWhpa28gU2F3YWRhDQogICAgRURCOiAgaHR0cHM6Ly93d3cuZW50ZXJw cmlzZWRiLmNvbS8NCg0KDQoNCg==