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 1hLyVM-0002UF-BY for pgsql-bugs@arkaria.postgresql.org; Wed, 01 May 2019 23:19:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLyVK-0003Np-Ve for pgsql-bugs@arkaria.postgresql.org; Wed, 01 May 2019 23:19:10 +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 1hLyVK-0003Ni-O2 for pgsql-bugs@lists.postgresql.org; Wed, 01 May 2019 23:19:10 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLyVH-0003Lv-UZ for pgsql-bugs@lists.postgresql.org; Wed, 01 May 2019 23:19:10 +0000 Content-Type: multipart/mixed; boundary="===============1435222438522239551==" MIME-Version: 1.0 Subject: BUG #15788: 'pg_dump --create' orders database GRANTs incorrectly To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: bossartn@amazon.com Reply-To: bossartn@amazon.com, pgsql-bugs@lists.postgresql.org Date: Wed, 01 May 2019 23:18:16 +0000 Message-ID: <15788-4e18847520ebcc75@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============1435222438522239551== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNTc4OApMb2dnZWQgYnk6ICAgICAgICAgIE5hdGhhbiBCb3NzYXJ0CkVt YWlsIGFkZHJlc3M6ICAgICAgYm9zc2FydG5AYW1hem9uLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IDExLjIKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eApEZXNjcmlwdGlvbjogICAgICAgIAoKSGVs bG8sDQoNCkN1cnJlbnRseSwgJ3BnX2R1bXAgLS1jcmVhdGUnIHdpbGwgZ2VuZXJhdGUgZGF0YWJh c2UgR1JBTlRzIGluIHRoZQ0Kd3Jvbmcgb3JkZXIsIHdoaWNoIGNhbiBsZWFkIHRvIFdBUk5JTkdz IG9yIEVSUk9ScyB3aGVuIGF0dGVtcHRpbmcgdG8NCnJlc3RvcmUgaXRzIG91dHB1dC4gIEhlcmUg aXMgYSBzaW1wbGUgd2F5IHRvIHJlcHJvZHVjZSB0aGUgaXNzdWU6DQoNCiAgMS4gQXMgYSBzdXBl cnVzZXIsIHJ1biB0aGUgZm9sbG93aW5nIFNRTCBjb21tYW5kcy4NCg0KICAgICAgICBDUkVBVEUg Uk9MRSBhX3VzZXI7DQogICAgICAgIENSRUFURSBST0xFIGJfdXNlciBXSVRIIENSRUFURVJPTEUg Q1JFQVRFREI7DQogICAgICAgIENSRUFURSBST0xFIGNfdXNlcjsNCiAgICAgICAgU0VUIFNFU1NJ T04gQVVUSE9SSVpBVElPTiBiX3VzZXI7DQogICAgICAgIENSRUFURSBEQVRBQkFTRSBteWRiOw0K DQogICAgICAgIFxjIG15ZGINCg0KICAgICAgICBTRVQgU0VTU0lPTiBBVVRIT1JJWkFUSU9OIGJf dXNlcjsNCiAgICAgICAgUkVWT0tFIEFMTCBPTiBEQVRBQkFTRSBteWRiIEZST00gcHVibGljOw0K ICAgICAgICBHUkFOVCBURU1QT1JBUlkgT04gREFUQUJBU0UgbXlkYiBUTyBjX3VzZXIgV0lUSCBH UkFOVCBPUFRJT047DQogICAgICAgIFNFVCBTRVNTSU9OIEFVVEhPUklaQVRJT04gY191c2VyOw0K ICAgICAgICBHUkFOVCBURU1QT1JBUlkgT04gREFUQUJBU0UgbXlkYiBUTyBhX3VzZXI7DQoNCiAg Mi4gVGhlbiwgZXhlY3V0ZSB0aGUgZm9sbG93aW5nIHBnX2R1bXAgYW5kIHBzcWwgY29tbWFuZHMu DQoNCiAgICAgICAgcGdfZHVtcCBteWRiIC1DIC1zIC1mIGR1bXAuc3FsDQogICAgICAgIHBzcWwg cG9zdGdyZXMgLWMgIkRST1AgREFUQUJBU0UgbXlkYjsiDQogICAgICAgIHBzcWwgcG9zdGdyZXMg LXEgLWMgIlxcc2V0IE9OX0VSUk9SX1NUT1AiIC1mIGR1bXAuc3FsDQoNClRoZSBsYXN0IHBzcWwg Y29tbWFuZCB3aWxsIGZhaWwgd2l0aCB0aGUgZm9sbG93aW5nIEVSUk9SOg0KDQogICAgICAgIEVS Uk9SOiAgcGVybWlzc2lvbiBkZW5pZWQgZm9yIGRhdGFiYXNlIG15ZGINCg0KSSB0aGluayB0aGUg dW5kZXJseWluZyBpc3N1ZSBpcyB0aGF0IHRoZSBwZ19kdW1wIHF1ZXJ5IGlzIHNvcnRpbmcgdGhl DQpBQ0xzLCB3aGljaCBtYXkgbm90IGJlIHRoZSBuYXR1cmFsIG9yZGVyaW5nLiAgSSB3YXMgYWJs ZSB0byBmaXggdGhpcw0KYnkgbWFraW5nIGEgdmVyeSBzaW1pbGFyIGNoYW5nZSB0byA2OGE3YzI0 ZiBpbiBkdW1wRGF0YWJhc2UoKS4NCg0KZGlmZiAtLWdpdCBhL3NyYy9iaW4vcGdfZHVtcC9wZ19k dW1wLmMgYi9zcmMvYmluL3BnX2R1bXAvcGdfZHVtcC5jDQppbmRleCBkYjhjYTQwYTc4Li4yOGU3 ODc1NmE4IDEwMDY0NA0KLS0tIGEvc3JjL2Jpbi9wZ19kdW1wL3BnX2R1bXAuYw0KKysrIGIvc3Jj L2Jpbi9wZ19kdW1wL3BnX2R1bXAuYw0KQEAgLTI2NzIsMTMgKzI2NzIsMjMgQEAgZHVtcERhdGFi YXNlKEFyY2hpdmUgKmZvdXQpDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICIoJXMgZGF0ZGJhKSBBUyBkYmEsICINCiAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKInBnX2VuY29kaW5nX3RvX2NoYXIoZW5jb2Rp bmcpIEFTIGVuY29kaW5nLCAiDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICJkYXRjb2xsYXRlLCBkYXRjdHlwZSwKZGF0ZnJvemVueGlkLCBkYXRtaW5t eGlkLCAiDQotICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICIoU0VMRUNUIGFycmF5X2FnZyhhY2wKT1JERVIgQlkgYWNsOjp0ZXh0IENPTExBVEUgXCJDXCIp IEZST00gKCAiDQotICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICIgIFNFTEVDVAp1bm5lc3QoY29hbGVzY2UoZGF0YWNsLGFjbGRlZmF1bHQoJ2QnLGRhdGRi YSkpKSBBUyBhY2wgIg0KLSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAiICBFWENFUFQgU0VMRUNUCnVubmVzdChhY2xkZWZhdWx0KCdkJyxkYXRkYmEpKSkg YXMgZGF0YWNscykiDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICIoU0VMRUNUIGFycmF5X2FnZyhhY2wKT1JERVIgQlkgcm93X24pIEZST00gIg0KKyAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiKFNFTEVDVCBh Y2wsIHJvd19uIEZST00KIg0KKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgIAoidW5uZXN0KGNvYWxlc2NlKGRhdGFjbCxhY2xkZWZhdWx0KCdkJyxkYXRkYmEp KSkgIg0KKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAi V0lUSCBPUkRJTkFMSVRZIEFTCnBlcm0oYWNsLHJvd19uKSAiDQorICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICJXSEVSRSBOT1QgRVhJU1RTICggIg0KKyAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiU0VMRUNUIDEg RlJPTSAiDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg CiJ1bm5lc3QoYWNsZGVmYXVsdCgnZCcsZGF0ZGJhKSkgIg0KKyAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAiQVMgaW5pdChpbml0X2FjbCkgV0hFUkUKYWNs ID0gaW5pdF9hY2wpKSBhcyBkYXRhY2xzKSINCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIiBBUyBkYXRhY2wsICINCi0gICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIihTRUxFQ1QgYXJyYXlfYWdnKGFjbApPUkRF UiBCWSBhY2w6OnRleHQgQ09MTEFURSBcIkNcIikgRlJPTSAoICINCi0gICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIiAgU0VMRUNUCnVubmVzdChhY2xkZWZh dWx0KCdkJyxkYXRkYmEpKSBBUyBhY2wgIg0KLSAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAiICBFWENFUFQgU0VMRUNUCnVubmVzdChjb2FsZXNjZShkYXRh Y2wsYWNsZGVmYXVsdCgnZCcsZGF0ZGJhKSkpKSBhcyByZGF0YWNscykiDQorICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICIoU0VMRUNUIGFycmF5X2FnZyhh Y2wKT1JERVIgQlkgcm93X24pIEZST00gIg0KKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAiKFNFTEVDVCBhY2wsIHJvd19uIEZST00KIg0KKyAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIAoidW5uZXN0KGFjbGRlZmF1 bHQoJ2QnLGRhdGRiYSkpICINCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgIldJVEggT1JESU5BTElUWSBBUwppbml0cChhY2wscm93X24pICINCisgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIldIRVJFIE5PVCBF WElTVFMgKCAiDQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICJTRUxFQ1QgMSBGUk9NICINCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAKInVubmVzdChjb2FsZXNjZShkYXRhY2wsYWNsZGVmYXVsdCgnZCcsZGF0 ZGJhKSkpICINCisgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgIkFTIHBlcm1wKG9yaWdfYWNsKSBXSEVSRQphY2wgPSBvcmlnX2FjbCkpIGFzIHJkYXRhY2xz KSINCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIiBB UyByZGF0YWNsLCAiDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICJkYXRpc3RlbXBsYXRlLApkYXRjb25ubGltaXQsICINCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIihTRUxFQ1Qgc3BjbmFtZSBGUk9NCnBn X3RhYmxlc3BhY2UgdCBXSEVSRSB0Lm9pZCA9IGRhdHRhYmxlc3BhY2UpIEFTIHRhYmxlc3BhY2Us ICINCg0KTmF0aGFuCgo= --===============1435222438522239551==--