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 1mxgJi-0003cq-15 for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 02:16:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mxgJB-0003Bb-Ev for pgsql-hackers@arkaria.postgresql.org; Thu, 16 Dec 2021 02:15:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxgJA-0003BS-UZ for pgsql-hackers@lists.postgresql.org; Thu, 16 Dec 2021 02:15:49 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mxgJ8-0007WJ-As for pgsql-hackers@postgresql.org; Thu, 16 Dec 2021 02:15:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1639620947; x=1671156947; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=CRmKGjcK1+SwLBxg/6JZ6wbW+4TBWxj+XkMrycPZ6A4=; b=AohN4PtGQOpmcqQOxPyCU6LG+FuoiLkX+8sDTIWGMtXALwr7yyoHgJxF Fq4RB+3kj40xtHuom9XTDTFX5lQDHLwhKyi+DfIbHQhAVsCocAik4jM7w VEi0LEMocPrvZztR5WeSBDZ7Ie6LiMkWmUz2XMJDuLETfoHX9twcozTLm s=; X-IronPort-AV: E=Sophos;i="5.88,210,1635206400"; d="scan'208";a="159303010" Subject: Re: Synchronizing slots from primary to standby Thread-Topic: Synchronizing slots from primary to standby Received: from iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-pdx-2a-39fdda15.us-west-2.amazon.com) ([10.43.8.2]) by smtp-border-fw-2101.iad2.amazon.com with ESMTP; 16 Dec 2021 02:15:45 +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-2a-39fdda15.us-west-2.amazon.com (Postfix) with ESMTPS id 9813F4276F; Thu, 16 Dec 2021 02:15:43 +0000 (UTC) Received: from EX13D11UWC004.ant.amazon.com (10.43.162.101) by EX13MTAUWB001.ant.amazon.com (10.43.161.207) with Microsoft SMTP Server (TLS) id 15.0.1497.26; Thu, 16 Dec 2021 02:15:42 +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.26; Thu, 16 Dec 2021 02:15:42 +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.026; Thu, 16 Dec 2021 02:15:42 +0000 From: "Hsu, John" To: Peter Eisentraut , Bharath Rupireddy CC: pgsql-hackers Thread-Index: AQHXzj+PGAwAyWbkU0uP+11wRgdchqwYrJiAgBopgACAAUzzAA== Date: Thu, 16 Dec 2021 02:15:42 +0000 Message-ID: <2415E2B4-F79E-4C24-A28E-78D40721D08F@amazon.com> References: <514f6f2f-6833-4539-39f1-96cd1e011f23@enterprisedb.com> <0ee342de-4422-809f-8e4d-fbd99370bed9@enterprisedb.com> In-Reply-To: <0ee342de-4422-809f-8e4d-fbd99370bed9@enterprisedb.com> 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.183] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SGVsbG8sDQoNCkkgc3RhcnRlZCB0YWtpbmcgYSBicmllZiBsb29rIGF0IHRoZSB2MiBwYXRjaCwg YW5kIGl0IGRvZXMgYXBwZWFyIHRvIHdvcmsgZm9yIHRoZSBiYXNpYyBjYXNlLiBMb2dpY2FsIHNs b3QgaXMgc3luY2hyb25pemVkIGFjcm9zcyBhbmQgSSBjYW4gY29ubmVjdCB0byB0aGUgcHJvbW90 ZWQgc3RhbmRieSBhbmQgc3RyZWFtIGNoYW5nZXMgYWZ0ZXJ3YXJkcy4NCg0KSXQncyBub3QgY2xl YXIgdG8gbWUgd2hhdCB0aGUgY29ycmVjdCBiZWhhdmlvciBpcyB3aGVuIGEgbG9naWNhbCBzbG90 IHRoYXQgaGFzIGJlZW4gc3luY2VkIHRvIHRoZSByZXBsaWNhIGFuZCB0aGVuIGl0IGdldHMgZGVs ZXRlZCBvbiB0aGUgd3JpdGVyLiBXb3VsZCB3ZSBleHBlY3QgdGhpcyB0byBiZSBwcm9wYWdhdGVk IG9yIGxlYXZlIGl0IHVwIHRvIHRoZSBlbmQtdXNlciB0byBtYW5hZ2U/DQoNCj4gKyAgICAgICBy YXduYW1lID0gcHN0cmR1cChzdGFuZGJ5X3Nsb3RfbmFtZXMpOw0KPiArICAgICAgIFNwbGl0SWRl bnRpZmllclN0cmluZyhyYXduYW1lLCAnLCcsICZuYW1lbGlzdCk7DQo+ICsNCj4gKyAgICAgICB3 aGlsZSAodHJ1ZSkNCj4gKyAgICAgICB7DQo+ICsgICAgICAgICAgICAgICBpbnQgICAgICAgICAg ICAgICAgICAgICB3YWl0X3Nsb3RzX3JlbWFpbmluZzsNCj4gKyAgICAgICAgICAgICAgIFhMb2dS ZWNQdHIgICAgICBvbGRlc3RfZmx1c2hfcG9zID0gSW52YWxpZFhMb2dSZWNQdHI7DQo+ICsgICAg ICAgICAgICAgICBpbnQgICAgICAgICAgICAgICAgICAgICByYzsNCj4gKw0KPiArICAgICAgICAg ICAgICAgd2FpdF9zbG90c19yZW1haW5pbmcgPSBsaXN0X2xlbmd0aChuYW1lbGlzdCk7DQo+ICsN Cj4gKyAgICAgICAgICAgICAgIExXTG9ja0FjcXVpcmUoUmVwbGljYXRpb25TbG90Q29udHJvbExv Y2ssIExXX1NIQVJFRCk7DQo+ICsgICAgICAgICAgICAgICBmb3IgKGludCBpID0gMDsgaSA8IG1h eF9yZXBsaWNhdGlvbl9zbG90czsgaSsrKQ0KPiArICAgICAgICAgICAgICAgew0KDQpFdmVuIHRo b3VnaCBzdGFuZGJ5X3Nsb3RfbmFtZXMgaXMgUEdDX1NJR0hVUCwgd2UgbmV2ZXIgcmVsb2FkL3Jl LXByb2Nlc3MgdGhlIHZhbHVlLiBJZiB3ZSBoYXZlIGEgd3JvbmcgZW50cnkgaW4gdGhlcmUsIHRo ZSBiYWNrZW5kIGJlY29tZXMgc3R1Y2sgdW50aWwgd2UgcmUtZXN0YWJsaXNoIHRoZSBsb2dpY2Fs IGNvbm5lY3Rpb24uIEFkZGluZyAicG9zdG1hc3Rlci9pbnRlcnJ1cHQuaCIgd2l0aCBDb25maWdS ZWxvYWRQZW5kaW5nIC8gUHJvY2Vzc0NvbmZpZ0ZpbGUgZG9lcyBzZWVtIHRvIHdvcmsuDQoNCkFu b3RoZXIgdGhpbmcgSSBub3RpY2VkIGlzIHRoYXQgb25jZSBpdCBzdGFydHMgd2FpdGluZyBpbiB0 aGlzIGJsb2NrLCBDdHJsK0MgZG9lc24ndCBzZWVtIHRvIHRlcm1pbmF0ZSB0aGUgYmFja2VuZD8N Cg0KcGdfcmVjdmxvZ2ljYWwgLWQgcG9zdGdyZXMgLXAgNTQzMiAtLXNsb3QgcmVncmVzc2lvbl9z bG90IC0tc3RhcnQgLWYgLQ0KLi4NCl5DcGdfcmVjdmxvZ2ljYWw6IGVycm9yOiB1bmV4cGVjdGVk IHRlcm1pbmF0aW9uIG9mIHJlcGxpY2F0aW9uIHN0cmVhbTogDQoNClRoZSBsb2dpY2FsIGJhY2tl bmQgY29ubmVjdGlvbiBpcyBzdGlsbCBwcmVzZW50Og0KDQpwcyBhdXggfCBncmVwIDUxMjYzDQog ICBoc3VjaGVuIDUxMjYzIDgwLjcgIDAuMCAzMjAxODAgMTQzMDQgPyAgICAgICAgUnMgICAwMTox MSAgIDM6MDQgcG9zdGdyZXM6IHdhbHNlbmRlciBoc3VjaGVuIFtsb2NhbF0gU1RBUlRfUkVQTElD QVRJT04NCg0KcHN0YWNrIDUxMjYzDQojMCAgMHgwMDAwN2ZmZWU5OWU3OWE1IGluIGNsb2NrX2dl dHRpbWUgKCkNCiMxICAweDAwMDA3Zjg3MDVlODgyNDYgaW4gY2xvY2tfZ2V0dGltZSAoKSBmcm9t IC9saWI2NC9saWJjLnNvLjYNCiMyICAweDAwMDAwMDAwMDA3NWYxNDEgaW4gV2FpdEV2ZW50U2V0 V2FpdCAoKQ0KIzMgIDB4MDAwMDAwMDAwMDc1ZjU2NSBpbiBXYWl0TGF0Y2ggKCkNCiM0ICAweDAw MDAwMDAwMDA3MjBhZWEgaW4gUmVvcmRlckJ1ZmZlclByb2Nlc3NUWE4gKCkNCiM1ICAweDAwMDAw MDAwMDA3MTQyYTYgaW4gRGVjb2RlWGFjdE9wICgpDQojNiAgMHgwMDAwMDAwMDAwNzE0NjBmIGlu IExvZ2ljYWxEZWNvZGluZ1Byb2Nlc3NSZWNvcmQgKCkNCg0KSXQgY2FuIGJlIHRlcm1pbmF0ZWQg d2l0aCBhIHBnX3Rlcm1pbmF0ZV9iYWNrZW5kIHRob3VnaC4NCg0KSWYgd2UgaGF2ZSBhIHBoeXNp Y2FsIHNsb3Qgd2l0aCBuYW1lIGZvbyBvbiB0aGUgc3RhbmRieSwgYW5kIHRoZW4gYSBsb2dpY2Fs IHNsb3QgaXMgY3JlYXRlZCBvbiB0aGUgd3JpdGVyIHdpdGggdGhlIHNhbWUgc2xvdF9uYW1lIGl0 IGRvZXMgZXJyb3Igb3V0IG9uIHRoZSByZXBsaWNhIGFsdGhvdWdoIGl0IHByZXZlbnRzIG90aGVy IHNsb3RzIGZyb20gYmVpbmcgc3luY2hyb25pemVkIHdoaWNoIGlzIHByb2JhYmx5IGZpbmUuDQoN CjIwMjEtMTItMTYgMDI6MTA6MjkuNzA5IFVUQyBbNzM3ODhdIExPRzogIHJlcGxpY2F0aW9uIHNs b3Qgc3luY2hyb25pemF0aW9uIHdvcmtlciBmb3IgZGF0YWJhc2UgInBvc3RncmVzIiBoYXMgc3Rh cnRlZA0KMjAyMS0xMi0xNiAwMjoxMDoyOS43MTMgVVRDIFs3Mzc4OF0gRVJST1I6ICBjYW5ub3Qg dXNlIHBoeXNpY2FsIHJlcGxpY2F0aW9uIHNsb3QgZm9yIGxvZ2ljYWwgZGVjb2RpbmcNCjIwMjEt MTItMTYgMDI6MTA6MjkuNzE0IFVUQyBbNzMwMzddIERFQlVHOiAgdW5yZWdpc3RlcmluZyBiYWNr Z3JvdW5kIHdvcmtlciAicmVwbGljYXRpb24gc2xvdCBzeW5jaHJvbml6YXRpb24gd29ya2VyIg0K DQrvu79PbiAxMi8xNC8yMSwgMjoyNiBQTSwgIlBldGVyIEVpc2VudHJhdXQiIDxwZXRlci5laXNl bnRyYXV0QGVudGVycHJpc2VkYi5jb20+IHdyb3RlOg0KDQogICAgQ0FVVElPTjogVGhpcyBlbWFp bCBvcmlnaW5hdGVkIGZyb20gb3V0c2lkZSBvZiB0aGUgb3JnYW5pemF0aW9uLiBEbyBub3QgY2xp Y2sgbGlua3Mgb3Igb3BlbiBhdHRhY2htZW50cyB1bmxlc3MgeW91IGNhbiBjb25maXJtIHRoZSBz ZW5kZXIgYW5kIGtub3cgdGhlIGNvbnRlbnQgaXMgc2FmZS4NCg0KDQoNCiAgICBPbiAyOC4xMS4y MSAwNzo1MiwgQmhhcmF0aCBSdXBpcmVkZHkgd3JvdGU6DQogICAgPiAxKSBJbnN0ZWFkIG9mIGEg bmV3IExJU1RfU0xPVCBjb21tYW5kLCBjYW4ndCB3ZSB1c2UNCiAgICA+IFJFQURfUkVQTElDQVRJ T05fU0xPVCAoc2xpZ2h0IG1vZGlmaWNhdGlvbnMgbmVlZHMgdG8gYmUgZG9uZSB0byBtYWtlDQog ICAgPiBpdCBzdXBwb3J0IGxvZ2ljYWwgcmVwbGljYXRpb24gc2xvdHMgYW5kIHRvIGdldCBtb3Jl IGluZm9ybWF0aW9uIGZyb20NCiAgICA+IHRoZSBzdWJzY3JpYmVyKS4NCg0KICAgIEkgbG9va2Vk IGF0IHRoYXQgYnV0IGRpZG4ndCBzZWUgYW4gb2J2aW91cyB3YXkgdG8gY29uc29saWRhdGUgdGhl bS4NCiAgICBUaGlzIGlzIHNvbWV0aGluZyB3ZSBjb3VsZCBsb29rIGF0IGFnYWluIGxhdGVyLg0K DQogICAgPiAyKSBIb3cgZnJlcXVlbnRseSB0aGUgbmV3IGJnIHdvcmtlciBpcyBnb2luZyB0byBz eW5jIHRoZSBzbG90IGluZm8/DQogICAgPiBIb3cgY2FuIGl0IGVuc3VyZSB0aGF0IHRoZSBsYXRl c3QgaW5mb3JtYXRpb24gZXhpc3RzIHNheSB3aGVuIHRoZQ0KICAgID4gc3Vic2NyaWJlciBpcyBk b3duL2NyYXNoZWQgYmVmb3JlIGl0IHBpY2tzIHVwIHRoZSBsYXRlc3Qgc2xvdA0KICAgID4gaW5m b3JtYXRpb24/DQoNCiAgICBUaGUgaW50ZXJ2YWwgaXMgY3VycmVudGx5IGhhcmRjb2RlZCwgYnV0 IGNvdWxkIGJlIGEgY29uZmlndXJhdGlvbg0KICAgIHNldHRpbmcuICBJbiB0aGUgdjIgcGF0Y2gs IHRoZXJlIGlzIGEgbmV3IHNldHRpbmcgdGhhdCBvcmRlcnMgcGh5c2ljYWwNCiAgICByZXBsaWNh dGlvbiBiZWZvcmUgbG9naWNhbCBzbyB0aGF0IHRoZSBsb2dpY2FsIHN1YnNjcmliZXJzIGNhbm5v dCBnZXQNCiAgICBhaGVhZCBvZiB0aGUgcGh5c2ljYWwgc3RhbmRieS4NCg0KICAgID4gMykgSW5z dGVhZCBvZiB0aGUgc3Vic2NyaWJlciBwdWxsaW5nIHRoZSBzbG90IGluZm8sIHdoeSBjYW4ndCB0 aGUNCiAgICA+IHB1Ymxpc2hlciAodmlhIHRoZSB3YWxzZW5kZXIgb3IgYSBuZXcgYmcgd29ya2Vy IG1heWJlPykgcHVzaCB0aGUNCiAgICA+IGxhdGVzdCBzbG90IGluZm8/IEknbSBub3Qgc3VyZSB3 ZSB3YW50IHRvIGFkZCBtb3JlIGZ1bmN0aW9uYWxpdHkgdG8NCiAgICA+IHRoZSB3YWxzZW5kZXIs IGlmIHllcywgaXNuJ3QgaXQgZ29pbmcgdG8gYmUgbXVjaCBzaW1wbGVyPw0KDQogICAgVGhpcyBz b3VuZHMgbGlrZSB0aGUgZmFpbG92ZXIgc2xvdCBmZWF0dXJlLCB3aGljaCB3YXMgcmVqZWN0ZWQu DQoNCg0KDQo=