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 1pKLq0-0005N0-93 for pgsql-general@arkaria.postgresql.org; Tue, 24 Jan 2023 16:07:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pKLpz-0000wc-18 for pgsql-general@arkaria.postgresql.org; Tue, 24 Jan 2023 16:07:55 +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 1pKLpy-0000wT-N2 for pgsql-general@lists.postgresql.org; Tue, 24 Jan 2023 16:07:54 +0000 Received: from mx4.stadt-zuerich.ch ([194.56.33.13]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pKLpv-0007lC-88 for pgsql-general@lists.postgresql.org; Tue, 24 Jan 2023 16:07:53 +0000 IronPort-SDR: ZDZOR2wdeQ/iBg7h+z+01fFkbc5jabq6a9+4BlomYUPzpsZ3SoBvx6YfOK0c6IwFsP5hfrFk3F XmFwX6d0wcnzV60qq9exqKmhrA8fTNnqgn6XHqBSMNz/ZaGdVL03DOOE/7RhFnrb/px8mG3OLj zNl1RpzPWq1UOk5K8V+P7kVfAkewqbE3MpJKeYSPtucxrsd2gUXz6TaK5SiMmc80HheHScPYdb aI4QK/d9t7MghwoS6UH6K8mt0xrs54/0cbkObhQo/KKIayvN4Zo4HLqzqrFQiMQo1ljYYfdRDE pFc= X-IronPort-AV: E=Sophos;i="5.97,242,1669071600"; d="scan'208";a="36033999" Received: from unknown (HELO SZHM29234.global.szh.loc) ([10.7.50.100]) by mx4.prm.szh.zone with ESMTP/TLS/AES256-GCM-SHA384; 24 Jan 2023 17:07:47 +0100 Received: from SZHM27370.global.szh.loc (10.7.50.50) by SZHM29234.global.szh.loc (10.7.50.103) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256) id 15.1.2375.18; Tue, 24 Jan 2023 17:07:46 +0100 Received: from SZHM27370.global.szh.loc ([fe80::25ce:879f:5795:3325]) by SZHM27370.global.szh.loc ([fe80::25ce:879f:5795:3325%19]) with mapi id 15.01.2375.018; Tue, 24 Jan 2023 17:07:46 +0100 From: "Zwettler Markus (OIZ)" To: Christophe Pettus CC: "pgsql-general@lists.postgresql.org" Subject: AW: [Extern] Re: Is a logical replication crash recovery safe? Thread-Topic: [Extern] Re: Is a logical replication crash recovery safe? Thread-Index: AdkwCbY3ccG7S2s8TaKu2nzSZplraP//8iaA///qT1A= Date: Tue, 24 Jan 2023 16:07:46 +0000 Message-ID: References: <6d71f90e900c4b3f9e2654c6adc3a5ff@zuerich.ch> <92C9BEE0-7DA9-4C07-BABB-466E8D2EF000@thebuild.com> In-Reply-To: <92C9BEE0-7DA9-4C07-BABB-466E8D2EF000@thebuild.com> Accept-Language: de-CH, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.7.48.250] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiAtLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQo+IFZvbjogQ2hyaXN0b3BoZSBQ ZXR0dXMgPHhvZkB0aGVidWlsZC5jb20+DQo+IEdlc2VuZGV0OiBEaWVuc3RhZywgMjQuIEphbnVh ciAyMDIzIDE2OjQ4DQo+IEFuOiBad2V0dGxlciBNYXJrdXMgKE9JWikgPE1hcmt1cy5ad2V0dGxl ckB6dWVyaWNoLmNoPg0KPiBDYzogcGdzcWwtZ2VuZXJhbEBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0K PiBCZXRyZWZmOiBbRXh0ZXJuXSBSZTogSXMgYSBsb2dpY2FsIHJlcGxpY2F0aW9uIGNyYXNoIHJl Y292ZXJ5IHNhZmU/DQo+IA0KPiANCj4gDQo+ID4gT24gSmFuIDI0LCAyMDIzLCBhdCAwNzozNywg WndldHRsZXIgTWFya3VzIChPSVopIDxNYXJrdXMuWndldHRsZXJAenVlcmljaC5jaD4NCj4gd3Jv dGU6DQo+ID4NCj4gPiBJcyBhIGxvZ2ljYWwgcmVwbGljYXRpb24gY3Jhc2ggcmVjb3Zlcnkgc2Fm ZT8NCj4gDQo+IFlvdSBtaWdodCB3YW50IHRvIGdpdmUgbW9yZSBkZXRhaWwgYWJvdXQgdGhlIHNj ZW5hcmlvIHlvdSBhcmUgY29uY2VybmVkIGFib3V0Lg0KPiBDaGFuZ2VzIHRoYXQgYXJlIHJlY2Vp dmVkIGJ5IGEgc3Vic2NyaWJlciBhcyBwYXJ0IG9mIGxvZ2ljYWwgcmVwbGljYXRpb24gYXJlIFdB TC0NCj4gbG9nZ2VkLCBvYnNlcnZlIHRyYW5zYWN0aW9uIHNlbWFudGljcywgYW5kIHdpbGwgYmUg cmVwbGF5ZWQgaWYgdGhlIHN1YnNjcmliZXINCj4gY3Jhc2hlcyBhbmQgcmVzdGFydHMuDQo+IA0K DQoNClNvcnJ5LiBMZXQgbWUgcmVmaW5lLg0KDQpJZiBJIGNyZWF0ZSBhIGxvZ2ljYWwgcmVwbGlj YXRpb24gc2xvdCBhbmQgdXNlIHRoZSByZXBsaWNhdGlvbiBzbG90IHRvIHB1Ymxpc2ggc29tZSB0 YWJsZXMuDQoNCldpbGwgdGhlIGluZm9ybWF0aW9uIGluIHRoZSByZXBsaWNhdGlvbiBzbG90IGJl IHNhZmUgZm9yIGFueSBzdWJzY3JpcHRpb24gZXZlbiBpZiBhIGNyYXNoIHJlY292ZXJ5IGhhcHBl bmVkIG9uIHRoZSBwdWJsaXNoZXIgbm9kZT8NCg0KDQo=