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 1mb3Mr-0003nI-Dt for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Oct 2021 16:14:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mb3Mp-0000IZ-Vt for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Oct 2021 16:14:03 +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 1mb3Mp-0000IQ-OO for pgsql-bugs@lists.postgresql.org; Thu, 14 Oct 2021 16:14:03 +0000 Received: from smtp-fw-80007.amazon.com ([99.78.197.218]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mb3Mj-0004Ty-4v for pgsql-bugs@lists.postgresql.org; Thu, 14 Oct 2021 16:14:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634228038; x=1665764038; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=9C4tGSniHUDsj4/b6QDz1r94tRE+19fyxivRl2kvxnk=; b=sOEoJ1CXWwbb53yE3FxG35ICFytWRYckayoFYhnk1FECyhDOCWacmJ9N 7NN7Fb2xh0Uwnu8LcmeqxCgW8l15JyTLykm73JGXa/3R35Lvjwp08K4hb IoZFfktq1v8S/3e4kSpeAKALTjCq/TJ5o5kwQTfwaq0z5YnL5HDbe6yQQ Y=; X-IronPort-AV: E=Sophos;i="5.85,372,1624320000"; d="scan'208";a="34219502" Subject: Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES Thread-Topic: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES Received: from pdx4-co-svc-p1-lb2-vlan2.amazon.com (HELO email-inbound-relay-pdx-2c-90419278.us-west-2.amazon.com) ([10.25.36.210]) by smtp-border-fw-80007.pdx80.corp.amazon.com with ESMTP; 14 Oct 2021 16:13:55 +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-90419278.us-west-2.amazon.com (Postfix) with ESMTPS id 4EE9E42387; Thu, 14 Oct 2021 16:13:54 +0000 (UTC) Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.23; Thu, 14 Oct 2021 16:13:54 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC004.ant.amazon.com (10.43.162.49) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Thu, 14 Oct 2021 16:13:53 +0000 Received: from EX13D03UWC004.ant.amazon.com ([10.43.162.49]) by EX13D03UWC004.ant.amazon.com ([10.43.162.49]) with mapi id 15.00.1497.024; Thu, 14 Oct 2021 16:13:53 +0000 From: "Bossart, Nathan" To: Michael Paquier , Masahiko Sawada CC: Tom Lane , Neil Chen , "Boris P. Korzun" , "pgsql-bugs@lists.postgresql.org" Thread-Index: AQHXJdpJyJumIMh23Em/jNp/lMWaUKuvAL4AgAFWgACADvokgIATihaAgABQRQmAACmvAIAAFnsA Date: Thu, 14 Oct 2021 16:13:52 +0000 Message-ID: <0C8283FD-5A1F-4C8E-8C93-257B10D80466@amazon.com> References: <8261632200581@mail.yandex.ru> <721942.1634180151@sss.pgh.pa.us> 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.43] Content-Type: text/plain; charset="utf-8" Content-ID: <4920C83DDBBFE94F869EBE6F57A62544@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 T24gMTAvMTQvMjEsIDEyOjU1IEFNLCAiTWljaGFlbCBQYXF1aWVyIiA8bWljaGFlbEBwYXF1aWVy Lnh5ej4gd3JvdGU6DQo+IDEpIEZvciBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIEZVTkNUSU9OUzoN Cj4gLUFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBGT1IgUk9MRSByZWdyZXNzX2R1bXBfdGVzdF9y b2xlIElOIFNDSEVNQQ0KPiAgICAgIGR1bXBfdGVzdCBSRVZPS0UgQUxMIE9OIEZVTkNUSU9OUyAg RlJPTSBQVUJMSUM7DQo+ICtBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgcmVncmVz c19kdW1wX3Rlc3Rfcm9sZSBJTiBTQ0hFTUENCj4gICAgICBkdW1wX3Rlc3QgR1JBTlQgQUxMIE9O IEZVTkNUSU9OUyAgVE8gcmVncmVzc19kdW1wX3Rlc3Rfcm9sZTsNCg0KVGhpcyBvbmUgbG9va3Mg Y29ycmVjdCB0byBtZS4NCg0KPiAyKSBGb3IgREVGQVVMVCBQUklWSUxFR0VTIEZPUiBUQUJMRVM6 DQo+IC1BTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgRk9SIFJPTEUgcmVncmVzc19kdW1wX3Rlc3Rf cm9sZSBJTiBTQ0hFTUENCj4gICAgICBkdW1wX3Rlc3QgUkVWT0tFIEFMTCBPTiBUQUJMRVMgIEZS T00gcmVncmVzc19kdW1wX3Rlc3Rfcm9sZTsNCj4gIEFMVEVSIERFRkFVTFQgUFJJVklMRUdFUyBG T1IgUk9MRSByZWdyZXNzX2R1bXBfdGVzdF9yb2xlIElOIFNDSEVNQQ0KPiAgICAgIGR1bXBfdGVz dCBHUkFOVCBTRUxFQ1QgT04gVEFCTEVTICBUTyByZWdyZXNzX2R1bXBfdGVzdF9yb2xlOw0KPg0K PiBTbyB0aGUgcGF0Y2ggcmVtb3ZlcyBhIFJFVk9LRSBBTEwgT04gVEFCTEVTIG9uDQo+IHJlZ3Jl c3NfZHVtcF90ZXN0X3JvbGUgYWZ0ZXIgdGhlIGFkZGl0aW9uIG9mIG9ubHkgdGhlIEdSQU5UIEVY RUNVVEUgT04NCj4gRlVOQ1RJT05TLiAgVGhhdCBzZWVtcyBvZmYuICBBbSBJIG1pc3Npbmcgc29t ZXRoaW5nPw0KDQpJIG1pZ2h0IGJlIG1pc3Npbmcgc29tZXRoaW5nIGFzIHdlbGwsIGJ1dCB0aGlz IG9uZSBsb29rcyBjb3JyZWN0IHRvDQptZSwgdG9vLiAgSSBzdXNwZWN0IHRoYXQgUkVWT0tFIHN0 YXRlbWVudCB3YXMgZ2VuZXJhdGVkIGJ5IGNvbXBhcmluZw0KYWdhaW5zdCB0aGUgd3JvbmcgZGVm YXVsdCBBQ0wgYW5kIHRoYXQgaXQgYWN0dWFsbHkgaGFzIG5vIGVmZmVjdC4NCg0KTmF0aGFuDQoN Cg==