Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iwVd4-0007PQ-49 for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jan 2020 18:30:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iwVd1-0007dR-Fl for pgsql-bugs@arkaria.postgresql.org; Tue, 28 Jan 2020 18:30:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iwVd1-0007dJ-7W for pgsql-bugs@lists.postgresql.org; Tue, 28 Jan 2020 18:30:23 +0000 Received: from out.exch024.serverdata.net ([64.78.48.31]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1iwVct-0006HK-Od for pgsql-bugs@lists.postgresql.org; Tue, 28 Jan 2020 18:30:22 +0000 Received: from MBX024-E6-VA-1.exch024.domain.local (10.219.10.144) by MBX024-E6-VA-2.exch024.domain.local (10.219.10.146) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P521) id 15.1.1913.5; Tue, 28 Jan 2020 13:30:12 -0500 Received: from MBX024-E6-VA-1.exch024.domain.local ([10.219.10.144]) by MBX024-E6-VA-1.exch024.domain.local ([10.219.10.144]) with mapi id 15.01.1913.005; Tue, 28 Jan 2020 13:30:12 -0500 From: Darryl Snover To: Alvaro Herrera CC: "pgsql-bugs@lists.postgresql.org" Subject: Re: BUG #16237: When restoring database, backend disconnects or crashes when foreign key is created Thread-Topic: BUG #16237: When restoring database, backend disconnects or crashes when foreign key is created Thread-Index: AQHV1gbHvKpRfrnHKU2jB73c+7ojQ6gAubaA Date: Tue, 28 Jan 2020 18:30:12 +0000 Message-ID: <5B072ABD-0923-4CAC-8F22-199651355EDB@electrainfo.com> References: <20200128181428.GA19971@alvherre.pgsql> In-Reply-To: <20200128181428.GA19971@alvherre.pgsql> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [208.58.43.37] 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: Precedence: bulk PiBPbiBKYW4gMjgsIDIwMjAsIGF0IDE6MTQgUE0sIEFsdmFybyBIZXJyZXJhIDxhbHZoZXJyZUAy bmRxdWFkcmFudC5jb20+IHdyb3RlOg0KPiANCj4gT24gMjAyMC1KYW4tMjgsIFBHIEJ1ZyByZXBv cnRpbmcgZm9ybSB3cm90ZToNCj4gDQo+PiBwZ19yZXN0b3JlOiBjcmVhdGluZyBGSyBDT05TVFJB SU5UDQo+PiAicHVibGljLmZpbGVfdHJhbnNpdF90cmFuc2FjdGlvbl9maWxlX3RyYW5zaXRfaWRf ZmtleSINCj4+IHBnX3Jlc3RvcmU6IGZyb20gVE9DIGVudHJ5IDM5NzI7IDI2MDYgNDE3Nzc5MiBG SyBDT05TVFJBSU5UDQo+PiBmaWxlX3RyYW5zaXRfdHJhbnNhY3Rpb25fZmlsZV90cmFuc2l0X2lk X2ZrZXkgcG9zdGdyZXMNCj4+IHBnX3Jlc3RvcmU6IGVycm9yOiBjb3VsZCBub3QgZXhlY3V0ZSBx dWVyeTogc2VydmVyIGNsb3NlZCB0aGUgY29ubmVjdGlvbg0KPj4gdW5leHBlY3RlZGx5DQo+PiAJ VGhpcyBwcm9iYWJseSBtZWFucyB0aGUgc2VydmVyIHRlcm1pbmF0ZWQgYWJub3JtYWxseQ0KPj4g CWJlZm9yZSBvciB3aGlsZSBwcm9jZXNzaW5nIHRoZSByZXF1ZXN0Lg0KPj4gQ29tbWFuZCB3YXM6 IEFMVEVSIFRBQkxFIE9OTFkgZmlsZV90cmFuc2l0X3RyYW5zYWN0aW9uDQo+PiAgICBBREQgQ09O U1RSQUlOVCBmaWxlX3RyYW5zaXRfdHJhbnNhY3Rpb25fZmlsZV90cmFuc2l0X2lkX2ZrZXkgRk9S RUlHTiBLRVkNCj4+IChmaWxlX3RyYW5zaXRfaWQpIFJFRkVSRU5DRVMgZmlsZV90cmFuc2l0KGZp bGVfdHJhbnNpdF9pZCk7DQo+IA0KPiBJcyBhbnkgb2YgdGhlc2UgdGFibGVzIChmaWxlX3RyYW5z aXRfdHJhbnNhY3Rpb24gYW5kIGZpbGVfdHJhbnNpdCkNCj4gcGFydGl0aW9uZWQ/DQo+IA0KDQpO byB0YWJsZXMgYXJlIHBhcnRpdGlvbmVkLiAgQW55IGF0dGVtcHRzIHRvIGNyZWF0ZSBhbnkgcmVm ZXJlbnRpYWwgaW50ZWdyaXR5IGNvbnN0cmFpbnQgb24gYW55IHRhYmxlcyBjYXVzZXMgdGhlIHNh bWUgY3Jhc2guDQoNCknigJltIHRyeWluZyB0byBwcnVuZSBkb3duIHRoZSBkYXRhYmFzZSB0byBy aWQgaXQgb2YgYW55IHByb3ByaWV0YXJ5IGRhdGEsIGFuZCBzZWUgaWYgSSBjYW4gZ2V0IGEgcmVw cm9kdWNpYmxlIHNtYWxsIHNldC4NCg0KLURhcnJ5bA==