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 1n1mqm-00025z-FC for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Dec 2021 10:03:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n1mql-0006ZF-5o for pgsql-bugs@arkaria.postgresql.org; Mon, 27 Dec 2021 10:03:27 +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 1n1lXA-0002fZ-6o for pgsql-bugs@lists.postgresql.org; Mon, 27 Dec 2021 08:39:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1lX8-0005fw-9M for pgsql-bugs@lists.postgresql.org; Mon, 27 Dec 2021 08:39:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=TbYWKM2xVC0RQ2UM9eNLyWziYg3NlzNkZYMRzTEyREE=; b=L2KbVuYGr02hsBuURIB7qQMaO+ C+JJU3teneBMuuuqJue3oVx5QympMd/nY9rgLFLJz8/DH2jGqi8tND5JcQAqOXEBzaUUlUIT6VY7X pdKxGOWeXSl03TR/L9Zwgf3FmJcplhU0md8lCG9sQgBslyomCiZt57VlwLp5UvUcqqtA70uGpYItw LZIibSyIbFIjNUmkk6Fiv8UynXfkwNNcVcj8ntalT+5c+7iu4QXuqQMHvZW9GBquY4gFLBDP5cUDa HOr8fSRZL/+k7QPBgNAoXGb5Moo+GvDCdRTqcvA4+yYD3pqUl60nh0iQ8BbHewE+n2vMzn61VpyMb 1SlBsCnw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n1lX6-00019B-SW for pgsql-bugs@lists.postgresql.org; Mon, 27 Dec 2021 08:39:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n1lX4-0008TV-Cx for pgsql-bugs@lists.postgresql.org; Mon, 27 Dec 2021 08:39:02 +0000 Content-Type: multipart/mixed; boundary="===============7034310972962159262==" MIME-Version: 1.0 Subject: BUG #17346: pg_upgrade fails with role granted by other role To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: andrewbille@gmail.com Reply-To: andrewbille@gmail.com, pgsql-bugs@lists.postgresql.org Date: Mon, 27 Dec 2021 08:38:17 +0000 Message-ID: <17346-f72b28bd1a341060@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7034310972962159262== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzM0NgpMb2dnZWQgYnk6ICAgICAgICAgIEFuZHJldyBCaWxsZQpFbWFp bCBhZGRyZXNzOiAgICAgIGFuZHJld2JpbGxlQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246 IFVuc3VwcG9ydGVkL1Vua25vd24KT3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMjAuMDQKRGVz Y3JpcHRpb246ICAgICAgICAKCkhlbGxvIQ0KQWZ0ZXIgdGhlIGNvbW1pdDoNCg0KY29tbWl0IDM3 MTA4N2QwMDZlMDQ5OTEwODBiZjE3Y2YyMjg3ZGIzOGQzZWE5MmUNCkF1dGhvcjogRGFuaWVsIEd1 c3RhZnNzb24gPGRndXN0YWZzc29uQHBvc3RncmVzcWwub3JnPg0KRGF0ZTogICBGcmkgTm92IDI2 IDE0OjAyOjAxIDIwMjEgKzAxMDANCg0KICAgIEZpeCBHUkFOVEVEIEJZIHN1cHBvcnQgaW4gUkVW T0tFIFJPTEUgc3RhdGVtZW50cw0KICAgIA0KICAgIENvbW1pdCA2YWFhYTc2YmIgYWRkZWQgc3Vw cG9ydCBmb3IgdGhlIEdSQU5URUQgQlkgY2xhdXNlIGluIEdSQU5UIGFuZA0KICAgIFJFVk9LRSBz dGF0ZW1lbnRzLCBidXQgbWlzc2VkIGFkZGluZyBzdXBwb3J0IGZvciBjaGVja2luZyB0aGUgcm9s ZSBpbg0KICAgIHRoZSBSRVZPS0UgUk9MRSBjYXNlLiBGaXggYnkgY2hlY2tpbmcgdGhhdCB0aGUg cGFyc2VkIHJvbGUgbWF0Y2hlcyB0aGUNCiAgICBDVVJSRU5UX1JPTEUvQ1VSUkVOVF9VU0VSIHJl cXVpcmVtZW50LCBhbmQgYWxzbyBhZGQgc29tZSB0ZXN0cyBmb3IgaXQuDQogICAgQmFja3BhdGNo IHRvIHYxNCB3aGVyZSBHUkFOVEVEIEJZIHN1cHBvcnQgd2FzIGludHJvZHVjZWQuDQogICAgDQog ICAgRGlzY3Vzc2lvbjoKaHR0cHM6Ly9wb3N0Z3IuZXMvbS9CN0Y2Njk5QS1BOTg0LTQ5NDMtQjlC Ri1DRUI4NEMwMDM1MjdAeWVzcWwuc2UNCiAgICBCYWNrcGF0Y2gtdGhyb3VnaDogMTQNCiAgICAN CnBnX3VwZ3JhZGUgZm9yIGV4YW1wbGUgZnJvbSAxMC4xOSB2ZXJzaW9uIGNhdXNlcyB0aGUgZXJy b3I6DQoNCjEwL2Jpbi9pbml0ZGIgLUQgZDEwDQoxNC9iaW4vaW5pdGRiIC1EIGQxNA0KMTAvYmlu L3BnX2N0bCAtRCBkMTAgLWwgbG9nZmlsZSBzdGFydA0KMTAvYmluL3BzcWwgLWMgIkNSRUFURSBS T0xFIHVzZXIxOyBDUkVBVEUgUk9MRSB1c2VyMjsgR1JBTlQgdXNlcjEgVE8gdXNlcjIKR1JBTlRF RCBCWSB1c2VyMTsiDQoxMC9iaW4vcGdfY3RsIC1EIGQxMCAtbCBsb2dmaWxlIHN0b3ANCjE0L2Jp bi9wZ191cGdyYWRlIC1kIGQxMCAtRCBkMTQgLWIgMTAuMTkvYmluLyAtQiAxNC9iaW4vDQoNCi4u Li4uLi4uLg0KQ29weWluZyBvbGQgcGdfbXVsdGl4YWN0L21lbWJlcnMgdG8gbmV3IHNlcnZlciAg ICAgICAgICAgICAgb2sNClNldHRpbmcgbmV4dCBtdWx0aXhhY3QgSUQgYW5kIG9mZnNldCBmb3Ig bmV3IGNsdXN0ZXIgICAgICAgIG9rDQpSZXNldHRpbmcgV0FMIGFyY2hpdmVzICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICBvaw0KU2V0dGluZyBmcm96ZW54aWQgYW5kIG1pbm14 aWQgY291bnRlcnMgaW4gbmV3IGNsdXN0ZXIgICAgICAgb2sNClJlc3RvcmluZyBnbG9iYWwgb2Jq ZWN0cyBpbiB0aGUgbmV3IGNsdXN0ZXIgICAgICAgICAgICAgICAgIA0KKmZhaWx1cmUqDQoNCkNv bnN1bHQgdGhlIGxhc3QgZmV3IGxpbmVzIG9mICJwZ191cGdyYWRlX3V0aWxpdHkubG9nIiBmb3IN CnRoZSBwcm9iYWJsZSBjYXVzZSBvZiB0aGUgZmFpbHVyZS4NCkZhaWx1cmUsIGV4aXRpbmcNCg0K TGFzdCBsaW5lcyBvZiBwZ191cGdyYWRlX3V0aWxpdHkubG9nOg0KLi4uDQpDUkVBVEUgUk9MRSAi dXNlcjIiOw0KQ1JFQVRFIFJPTEUNCkFMVEVSIFJPTEUgInVzZXIyIiBXSVRIIE5PU1VQRVJVU0VS IElOSEVSSVQgTk9DUkVBVEVST0xFIE5PQ1JFQVRFREIgTk9MT0dJTgpOT1JFUExJQ0FUSU9OIE5P QllQQVNTUkxTOw0KQUxURVIgUk9MRQ0KR1JBTlQgInVzZXIxIiBUTyAidXNlcjIiIEdSQU5URUQg QlkgInVzZXIxIjsNCnBzcWw6cGdfdXBncmFkZV9kdW1wX2dsb2JhbHMuc3FsOjM3OiBFUlJPUjog IGdyYW50b3IgbXVzdCBiZSBjdXJyZW50IHVzZXINCg0KDQpSZWdhcmRzISBBbmRyZXcgQmlsbGUK Cg== --===============7034310972962159262==--