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 1mcgDA-0007WQ-Rh for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Oct 2021 03:54:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mcgD9-0003sR-Nx for pgsql-bugs@arkaria.postgresql.org; Tue, 19 Oct 2021 03:54:47 +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 1mcgD9-0003sH-Dc for pgsql-bugs@lists.postgresql.org; Tue, 19 Oct 2021 03:54:47 +0000 Received: from smtp-fw-33001.amazon.com ([207.171.190.10]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mcgD6-00060W-BK for pgsql-bugs@lists.postgresql.org; Tue, 19 Oct 2021 03:54:47 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634615685; x=1666151685; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=U7sqxU48igSIcB3gEWZG1pEUTJB+q8qCSzt+YV3ilD4=; b=NISMb5RBidMQnsg0wMYIkdh76o/IuGWKi7P75TOuGDpL3Pm4a+iK3zI+ L9l3hOGZMUSX9xob+hT65k+/zBeN6B+qtfjmHc8Cntt77b44v/wuVaxRs QUmzuSURtcplRdJY+D+dESZCpFGYKNrdyzTeF0d9mIoBKMei7qu46J7kY o=; X-IronPort-AV: E=Sophos;i="5.85,383,1624320000"; d="scan'208";a="154241824" 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-pdx-2a-e6c05252.us-west-2.amazon.com) ([10.43.8.2]) by smtp-border-fw-33001.sea14.amazon.com with ESMTP; 19 Oct 2021 03:54:40 +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-e6c05252.us-west-2.amazon.com (Postfix) with ESMTPS id 8760E424CE; Tue, 19 Oct 2021 03:54:39 +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.24; Tue, 19 Oct 2021 03:54:39 +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; Tue, 19 Oct 2021 03:54:38 +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; Tue, 19 Oct 2021 03:54:38 +0000 From: "Bossart, Nathan" To: Tom Lane , Masahiko Sawada CC: Michael Paquier , Neil Chen , "Boris P. Korzun" , "pgsql-bugs@lists.postgresql.org" Thread-Index: AQHXJdpJyJumIMh23Em/jNp/lMWaUKuvAL4AgAFWgACADvokgIATihaAgABQRQmAACmvAIABD36AgAXO5gCAAJvLAIAAFN0A//+UjIA= Date: Tue, 19 Oct 2021 03:54:37 +0000 Message-ID: References: <8261632200581@mail.yandex.ru> <721942.1634180151@sss.pgh.pa.us> <1737876.1634613552@sss.pgh.pa.us> In-Reply-To: <1737876.1634613552@sss.pgh.pa.us> 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.160.157] 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 T24gMTAvMTgvMjEsIDg6MjAgUE0sICJUb20gTGFuZSIgPHRnbEBzc3MucGdoLnBhLnVzPiB3cm90 ZToNCj4gTWFzYWhpa28gU2F3YWRhIDxzYXdhZGEubXNoa0BnbWFpbC5jb20+IHdyaXRlczoNCj4+ IEkndmUgbG9va2VkIGF0IHRoZSBwYXRjaCBwcm9wb3NlZCB5b3UgcHJvcG9zZWQuIElmIHdlIGNh biBkZXBlbmQgb24NCj4+IGFjbGRlZmF1bHQoKSBiZWluZyBTVFJJQ1QgKHdoaWNoIGlzIGxlZ2l0 aW1hdGUgdG8gbWUpLCBJIHRoaW5rIHdlDQo+PiBkb24ndCBuZWVkIHRvIGJ1aWxkIGFuIGV4cHJl c3Npb24gZGVwZW5kaW5nIG9uIHRoZSBjYWxsZXIgKGkuZy4sDQo+PiBpc19kZWZhdWx0X2FjbCku IElmIGFjbGRlZmF1bHQoKSB3ZXJlIHRvIGJlY29tZSBub3QgU1RSSUNULCB3ZSBjb3VsZA0KPj4g ZGV0ZWN0IGl0IGJ5IHJlZ3Jlc3Npb24gdGVzdHMuIFdoYXQgZG8geW91IHRoaW5rPw0KPg0KPiBG V0lXLCBJJ20gd29ya2luZyBvbiBhIHJlZmFjdG9yaW5nIG9mIHRoaXMgbG9naWMgdGhhdCB3aWxs IGJyaW5nIHRoZQ0KPiBhY2xkZWZhdWx0KCkgY2FsbCBpbnRvIHRoZSBnZXREZWZhdWx0QUNMcyBj b2RlLCB3aGljaCB3b3VsZCBtZWFuIHRoYXQNCj4gd2Ugd29uJ3QgbmVlZCB0aGF0IGFzc3VtcHRp b24gYW55bW9yZSBhbnl3YXkuICBUaGUgY29kZSBhcyBJIGhhdmUgaXQNCj4gcHJvZHVjZXMgU1FM IGxpa2UNCg0KTmljZSENCg0KPiBTbyBJIHRoaW5rIHdlIGRvbid0IG5lZWQgdG8gd29ycnkgYWJv dXQgd2hldGhlciBhY2xkZWZhdWx0KCkgd2lsbCBzdGF5DQo+IHN0cmljdC4gIFRoaXMgcGF0Y2gg d2lsbCBvbmx5IG5lZWQgdG8gd29yayBpbiB0aGUgYmFjayBicmFuY2hlcy4NCg0KVGhpcyBzZWVt cyBmaW5lIHRvIG1lLCB0b28uICBJIGRvbid0IHRoaW5rIHJlbHlpbmcgb24gU1RSSUNUIGlzIGFu eQ0KYmV0dGVyIG9yIHdvcnNlIHRoYW4gYWRkaW5nIGEgZmxhZyBmb3IgdGhpcyBvbmUgc3BlY2lh bCBjYXNlLg0KDQorCQkvKg0KKwkJICogU2luY2UgdGhlIGRlZmF1bHQgZm9yIGEgZ2xvYmFsIGVu dHJ5IGlzIHRoZSBoYXJkLXdpcmVkIGRlZmF1bHQNCisJCSAqIEFDTCBmb3IgdGhlIHBhcnRpY3Vs YXIgb2JqZWN0IHR5cGUsIHdlIHBhc3MgZGVmYWNsb2JqdHlwZSBleGNlcHQNCisJCSAqIGZvciB0 aGUgY2FzZSBvZiAnUycgKERFRkFDTE9CSl9TRVFVRU5DRSkgd2hlcmUgd2UgbmVlZCB0bw0KKwkJ ICogdHJhbnNmb3JtIGl0IHRvICdzJyBzaW5jZSBhY2xkZWZhdWx0KCkgU1FMLWNhbGxhYmxlIGZ1 bmN0aW9uDQorCQkgKiBoYW5kbGVzICdzJyBhcyBhIHNlcXVlbmNlLiAgT24gdGhlIG90aGVyIGhh bmQsIHNpbmNlIHRoZSBkZWZhdWx0DQorCQkgKiBmb3Igbm9uLWdsb2JhbCBlbnRyaWVzIGlzIGFu IGVtcHR5IEFDTCB3ZSBwYXNzIE5VTEwuICBUaGlzIHdvcmtzDQorCQkgKiBiZWNhdXNlIGFjbGRl ZmF1bHQoKSBpcyBTVFJJQ1QuDQorCQkgKi8NCg0KSSdkIHNwbGl0IG91dCB0aGUgdHdvIHNwZWNp YWwgY2FzZXMgaW4gdGhlIGNvbW1lbnQuICBXaGF0IGRvIHlvdSB0aGluaw0KYWJvdXQgc29tZXRo aW5nIGxpa2UgdGhlIGZvbGxvd2luZz8NCg0KICAgICAgICAvKg0KICAgICAgICAgKiBCdWlsZCB0 aGUgZXhwcmVzc2lvbiBmb3IgZGV0ZXJtaW5pbmcgdGhlIG9iamVjdCB0eXBlLg0KICAgICAgICAg Kg0KICAgICAgICAgKiBXaGlsZSBwZ19kZWZhdWx0X2FjbCB1c2VzICdTJyBmb3Igc2VxdWVuY2Vz LCBhY2xkZWZhdWx0KCkNCiAgICAgICAgICogdXNlcyAncycsIHNvIHdlIG11c3QgdHJhbnNmb3Jt ICdTJyB0byAncycuDQogICAgICAgICAqDQogICAgICAgICAqIFRoZSBkZWZhdWx0IGZvciBhIHNj aGVtYS1sb2NhbCBkZWZhdWx0IEFDTCAoaS5lLiwgZW50cmllcw0KICAgICAgICAgKiBpbiBwZ19k ZWZhdWx0X2FjbCB3aXRoIGRlZmFjbG5hbWVzcGFjZSAhPSAwKSBpcyBhbiBlbXB0eQ0KICAgICAg ICAgKiBBQ0wuICBXZSB1c2UgTlVMTCBhcyB0aGUgb2JqZWN0IHR5cGUgZm9yIHRob3NlIGVudHJp ZXMsDQogICAgICAgICAqIHdoaWNoIGZvcmNlcyBhY2xkZWZhdWx0KCkgdG8gYWxzbyByZXR1cm4g TlVMTCBiZWNhdXNlIGl0IGlzDQogICAgICAgICAqIFNUUklDVC4NCiAgICAgICAgICovDQoNCisJ CWNyZWF0ZV9zcWwgICA9PiAnQUxURVIgREVGQVVMVCBQUklWSUxFR0VTDQorCQkJCQkgICBGT1Ig Uk9MRSByZWdyZXNzX2R1bXBfdGVzdF9yb2xlIElOIFNDSEVNQSBkdW1wX3Rlc3QNCisJCQkJCSAg IEdSQU5UIEVYRUNVVEUgT04gRlVOQ1RJT05TIFRPIHJlZ3Jlc3NfZHVtcF90ZXN0X3JvbGU7JywN CisJCXJlZ2V4cCA9PiBxci9eDQorCQkJXFFBTFRFUiBERUZBVUxUIFBSSVZJTEVHRVMgXEUNCisJ CQlcUUZPUiBST0xFIHJlZ3Jlc3NfZHVtcF90ZXN0X3JvbGUgSU4gU0NIRU1BIGR1bXBfdGVzdCBc RQ0KKwkJCVxRR1JBTlQgQUxMIE9OIEZVTkNUSU9OUyAgVE8gcmVncmVzc19kdW1wX3Rlc3Rfcm9s ZTtcRQ0KKwkJCS94bSwNCg0KSXQgY291bGQgYmUgYSBiaXQgY29uZnVzaW5nIHRoYXQgY3JlYXRl X3NxbCB1c2VzICJHUkFOVCBFWEVDVVRFIiBidXQNCndlIGV4cGVjdCB0byBzZWUgIkdSQU5UIEFM TC4iICBJSVVDIHRoaXMgaXMgY29ycmVjdCwgYnV0IG1heWJlIHdlDQpzaG91bGQgdXNlICJHUkFO VCBBTEwiIGluIGNyZWF0ZV9zcWwgc28gdGhhdCB0aGV5IG1hdGNoLg0KDQpOYXRoYW4NCg0K