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 1mb3CF-0003X9-7X for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Oct 2021 16:03:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mb3CE-0001iC-7L for pgsql-bugs@arkaria.postgresql.org; Thu, 14 Oct 2021 16:03:06 +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 1mb3Bb-00089R-0l for pgsql-bugs@lists.postgresql.org; Thu, 14 Oct 2021 16:02:27 +0000 Received: from smtp-fw-2101.amazon.com ([72.21.196.25]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mb3BX-0004Nv-T7 for pgsql-bugs@lists.postgresql.org; Thu, 14 Oct 2021 16:02:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634227344; x=1665763344; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=zkrg/ZSq9Ja+UEiTrbhyn/2xJqlLQ8Oaf4CflCj0HNo=; b=tMsqedxO3hn+CzgfAkZNporMpwogmzw9FpAxomfKZ+FpX+t0AQtheF2N RN8qeaZfaRj7Fki4KgkBh4/pPAfT088qZo3zyawE3CBaVCT9naK/JC7fu OL6I96V+vyBHRt50KBBGBkzi8MOB3ugmIaKZQFhSbgOkxFW36EkKfNwHE M=; X-IronPort-AV: E=Sophos;i="5.85,372,1624320000"; d="scan'208";a="144691705" 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 iad12-co-svc-p1-lb1-vlan2.amazon.com (HELO email-inbound-relay-iad-1d-10222bbc.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-2101.iad2.amazon.com with ESMTP; 14 Oct 2021 16:02:20 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1d-10222bbc.us-east-1.amazon.com (Postfix) with ESMTPS id DBC331A0A13; Thu, 14 Oct 2021 16:02:17 +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:02:15 +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:02:15 +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:02:15 +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/lMWaUKuvAL4AgAFWgACADvokgIATihaAgABQRQmAACmvAIAAEzyA Date: Thu, 14 Oct 2021 16:02:15 +0000 Message-ID: <360E61F1-DF85-40D3-A091-120E98566CD4@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.147] Content-Type: text/plain; charset="utf-8" Content-ID: <337A314A6EC35047AF3AC79533B452E8@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+IFNvIHRoZSBwYXRjaCByZW1vdmVzIGEgUkVWT0tFIEFMTCBPTiBUQUJM RVMgb24NCj4gcmVncmVzc19kdW1wX3Rlc3Rfcm9sZSBhZnRlciB0aGUgYWRkaXRpb24gb2Ygb25s eSB0aGUgR1JBTlQgRVhFQ1VURSBPTg0KPiBGVU5DVElPTlMuICBUaGF0IHNlZW1zIG9mZi4gIEFt IEkgbWlzc2luZyBzb21ldGhpbmc/DQoNClRoaXMgaXNzdWUgaXMgYWxzbyB0cmFja2VkIGhlcmU6 DQoNCiAgICAgICAgaHR0cHM6Ly9jb21taXRmZXN0LnBvc3RncmVzcWwub3JnLzM1LzMyODgvDQoN CkkgaGFkIGF0dGVtcHRlZCB0byBmaXggdGhpcyBieSByZXBsYWNpbmcgYWNsZGVmYXVsdCgpIHdp dGggTlVMTCB3aGVuDQpkZWZhY2xuYW1lc3BhY2Ugd2FzIDAuICBGcm9tIGEgcXVpY2sgZ2xhbmNl LCB0aGUgcGF0Y2ggaW4gdGhpcyB0aHJlYWQNCnNlZW1zIHRvIGJlIGFkanVzdGluZyBvYmpfa2lu ZCBiYXNlZCBvbiB3aGV0aGVyIGRlZmFjbG5hbWVzcGFjZSBpcyAwLg0KSSB0aGluayB0aGlzIGhh cyB0aGUgc2FtZSBlZmZlY3QgYmVjYXVzZSBhY2xkZWZhdWx0KCkgaXMgU1RSSUNULg0KDQpOYXRo YW4NCg0K