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 1p5DJa-0001lG-21 for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Dec 2022 21:59:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1p5DJX-000775-Ee for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Dec 2022 21:59:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5AVf-0001Ti-7H for pgsql-bugs@lists.postgresql.org; Tue, 13 Dec 2022 19:00:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1p5AVb-0003nw-6j for pgsql-bugs@lists.postgresql.org; Tue, 13 Dec 2022 19:00:10 +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=2ezRNvwMl8LTnlF0dDLxlolByzqRZNDwJJk/lXDHcsY=; b=Nes6V+ZN2En8FXL8Kxt2/h1Av+ aGWx2Hh8jWd8TVrZcaCNq9WHX7xx5fVQnhqAxNm0bLcOApj5aAEfPFd86gVb+MGA/jY89g2wVZzVN NwEVGHTXQZC/isK7jbs4nX8oIX0S7glgT6I+roKnzomcvOoLXDiGIheAe7Kjk5muPlnVdbDyjUHOp EEB8bylBU1XWBiS7mZInN7PNyZ6+CnNmIEi8+KJ6shwWsMsq0t2LGI5zjAaIsUej9wsqVg1/3JxFm HnxW4vrGNsjgomtWZb0Nlqmm+whFyJFfLqxKKt7uDUMfD6yAv3OT5ol1PT78uCajByh+VNmih9FxL iCh1tBug==; 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 1p5AVa-0002Rw-33 for pgsql-bugs@lists.postgresql.org; Tue, 13 Dec 2022 19:00:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1p5AVW-00DZe9-Dv for pgsql-bugs@lists.postgresql.org; Tue, 13 Dec 2022 19:00:02 +0000 Content-Type: multipart/mixed; boundary="===============3835385111754708654==" MIME-Version: 1.0 Subject: BUG #17718: Unexpected REVOKE ALL permissions in the backup script To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kravtsov.k@gmail.com Reply-To: kravtsov.k@gmail.com, pgsql-bugs@lists.postgresql.org Date: Tue, 13 Dec 2022 18:59:18 +0000 Message-ID: <17718-f2d102527fc03c7a@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 --===============3835385111754708654== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzcxOApMb2dnZWQgYnk6ICAgICAgICAgIEtpcmlsbCBLcmF2dHNvdgpF bWFpbCBhZGRyZXNzOiAgICAgIGtyYXZ0c292LmtAZ21haWwuY29tClBvc3RncmVTUUwgdmVyc2lv bjogMTQuNQpPcGVyYXRpbmcgc3lzdGVtOiAgIENlbnRvcyA3CkRlc2NyaXB0aW9uOiAgICAgICAg CgpIZWxsbywNCknigJltIGZhY2luZyBhbiB1bmV4cGVjdGVkIGJlaGF2aW91ciBpbiBwZ19kdW1w IHdoZW4gdXNlZCBhZnRlciBpc3N1aW5nIGEKUkVBU1NJR04gT1dORUQgc3RhdGVtZW50IGluIHRo ZSBkYXRhYmFzZS4gRm9yIHRoZSBwcm9ibGVtIHRvIGFwcGVhciwgb25lCm5lZWQgdG8gY3JlYXRl IGFuIGV4dGVuc2lvbiB0aGF0IGNyZWF0ZXMgZGF0YWJhc2Ugb2JqZWN0cyBhcyBhIHNwZWNpZmlj IHVzZXIKYW5kIHRoZW4gaXNzdWUgUkVBU1NJR04gT1dORUQgZnJvbSB0aGF0IHVzZXIgdG8gYW5v dGhlci4gVGhlcmUgYXJlIHR3bwpkaXN0aW5jdCBwcm9ibGVtcyB0aGF0IEkgb2JzZXJ2ZSB3aGVu IHJ1bm5pbmcgcGdfZHVtcCBhZ2FpbnN0IHRoYXQKZGF0YWJhc2U6DQoxKSBUaGUgZXh0ZW5zaW9u LWdlbmVyYXRlZCBvYmplY3RzIG5vdyBlbWl0IFJFVk9LRSBBTEwgLi4uIEZST00gInVzZXIiIHdo ZXJlCnVzZXIgaXMgdGhlIHJvbGUgdGhhdCBvcmlnaW5hbGx5IGNyZWF0ZWQgdGhlIGV4dGVuc2lv bi4gVGhpcyBjcmVhdGVzIGEKZGVwZW5kZW5jeSB0aGF0IHNob3VsZG4ndCBleGlzdCBzaW5jZSBh bGwgdGhlIHBlcm1pc3Npb25zIGFyZSBzdXBwb3NlZCB0byBiZQpyZWFzc2lnbmVkIHRvIGEgbmV3 IHVzZXIuDQoyKSBJZiB0aGUgdXNlciBpcyBkcm9wcGVkLCB0aGUgc3RhdGVtZW50IG5vdyBtZW50 aW9ucyB0aGUgcm9sZSBPSUQgaW5zdGVhZApvZiByb2xlIG5hbWUuDQoNCkhhdmluZyB0aG9zZSBk ZXBlbmRlbmNpZXMgaW4gdGhlIGJhY2t1cCBzY3JpcHQgYnJlYWtzIHNvbWUgb2YgdGhlIGF1dG9t YXRpb24KYnkgZ2VuZXJhdGluZyBzdGF0ZW1lbnRzIHRoYXQgY2F1c2UgYSBub24temVybyBleGl0 IGNvZGUgd2hlbiByZXN0b3JpbmcgdGhlCkRCLiBJIGRvbid0IHdhbnQgdG8gaWdub3JlIHRoZSBl eGl0IGNvZGUgaW4gdGhpcyBzY2VuYXJpbywgYW5kIEkgZG9uJ3QgaGF2ZQphbiBhYmlsaXR5IHRv IGV4Y2x1ZGUgdGhvc2Ugb2JqZWN0cyBmcm9tIHRoZSBiYWNrdXAsIHNvIEkgd291bGQgYXBwcmVj aWF0ZQppZiBzb21lb25lIGNvdWxkIGxvb2sgaW50byB0aGlzLg0KDQpIb3cgdG8gcmVwcm9kdWNl Og0KIyBzZXR1cA0KcHNxbCA8PCBFT0YNCkNSRUFURSBST0xFIHRlc3R1c2VyOw0KQ1JFQVRFIFJP TEUgdGVzdHN1cGVyIFNVUEVSVVNFUjsNCkNSRUFURSBEQVRBQkFTRSBkYjEgT1dORVIgdGVzdHVz ZXIgVEVNUExBVEUgdGVtcGxhdGUwOw0KRU9GDQoNCiMgY3JlYXRpbmcgYW4gZXh0ZW5zaW9uIHRo YXQgY3JlYXRlcyBzeXN0ZW0gb2JqZWN0cyBpbiB0aGUgREINCnBzcWwgLWQgZGIxICAtYyAiU0VU IFJPTEUgdGVzdHN1cGVyOyBDUkVBVEUgRVhURU5TSU9OIHBnX2J1ZmZlcmNhY2hlIg0KDQojIHJl YXNzaWduIG93bmVkIGZyb20gc3VwZXIgdG8gcmVndWxhcg0KcHNxbCAtZCBkYjEgLWMgIlJFQVNT SUdOIE9XTkVEIEJZIHRlc3RzdXBlciBUTyB0ZXN0dXNlciINCg0KIyBvYnNlcnZlIHJlZmVyZW5j ZXMgdG8gdGhlIHN1cGVyIHN0aWxsIGV4aXN0DQpwZ19kdW1wIC1kIGRiMSB8IGdyZXAgJ1JFVk9L RSBBTEwnDQoNCiMgZGlzcGxheSB0aGUgT0lEIG9mIHRoZSBzdXBlciByb2xlDQpwc3FsIC1jICJT RUxFQ1Qgb2lkIEZST00gcGdfcm9sZXMgd2hlcmUgcm9sbmFtZSA9ICd0ZXN0c3VwZXInIg0KDQoj IGRyb3Agc3VwZXIgcm9sZQ0KcHNxbCAtYyAiRFJPUCBST0xFIHRlc3RzdXBlciINCg0KIyBvYnNl cnZlIG9pZCByZWZlcmVuY2UgaW4gdGhlIHNjcmlwdA0KcGdfZHVtcCAtZCBkYjEgfCBncmVwICdS RVZPS0UgQUxMJw0KDQojIGNsZWFudXANCnBzcWwgPDwgRU9GDQpEUk9QIERBVEFCQVNFIElGIEVY SVNUUyBkYjE7DQpEUk9QIFJPTEUgSUYgRVhJU1RTIHRlc3R1c2VyOw0KRFJPUCBST0xFIElGIEVY SVNUUyB0ZXN0c3VwZXI7DQpFT0YNCg0KDQpTYW1wbGUgb3V0cHV0Og0KJCAjIHNldHVwDQokIHBz cWwgPDwgRU9GDQo+IENSRUFURSBST0xFIHRlc3R1c2VyOw0KPiBDUkVBVEUgUk9MRSB0ZXN0c3Vw ZXIgU1VQRVJVU0VSOw0KPiBDUkVBVEUgREFUQUJBU0UgZGIxIE9XTkVSIHRlc3R1c2VyIFRFTVBM QVRFIHRlbXBsYXRlMDsNCj4gRU9GDQpDUkVBVEUgUk9MRQ0KQ1JFQVRFIFJPTEUNCkNSRUFURSBE QVRBQkFTRQ0KJCAjIGNyZWF0aW5nIGFuIGV4dGVuc2lvbiB0aGF0IGNyZWF0ZXMgc3lzdGVtIG9i amVjdHMgaW4gdGhlIERCDQokIHBzcWwgLWQgZGIxICAtYyAiU0VUIFJPTEUgdGVzdHN1cGVyOyBD UkVBVEUgRVhURU5TSU9OIHBnX2J1ZmZlcmNhY2hlIg0KQ1JFQVRFIEVYVEVOU0lPTg0KJCAjIHJl YXNzaWduIG93bmVkIGZyb20gc3VwZXIgdG8gcmVndWxhcg0KJCBwc3FsIC1kIGRiMSAtYyAiUkVB U1NJR04gT1dORUQgQlkgdGVzdHN1cGVyIFRPIHRlc3R1c2VyIg0KUkVBU1NJR04gT1dORUQNCiQg IyBvYnNlcnZlIHJlZmVyZW5jZXMgdG8gdGhlIHN1cGVyIHN0aWxsIGV4aXN0DQokIHBnX2R1bXAg LWQgZGIxIHwgZ3JlcCAnUkVWT0tFIEFMTCcNClJFVk9LRSBBTEwgT04gRlVOQ1RJT04gcHVibGlj LnBnX2J1ZmZlcmNhY2hlX3BhZ2VzKCkgRlJPTSB0ZXN0c3VwZXI7DQpSRVZPS0UgQUxMIE9OIEZV TkNUSU9OIHB1YmxpYy5wZ19idWZmZXJjYWNoZV9wYWdlcygpIEZST00gcGdfbW9uaXRvcjsNClJF Vk9LRSBBTEwgT04gVEFCTEUgcHVibGljLnBnX2J1ZmZlcmNhY2hlIEZST00gdGVzdHN1cGVyOw0K JCAjIGRpc3BsYXkgdGhlIE9JRCBvZiB0aGUgc3VwZXIgcm9sZQ0KJCBwc3FsIC1jICJTRUxFQ1Qg b2lkIEZST00gcGdfcm9sZXMgd2hlcmUgcm9sbmFtZSA9ICd0ZXN0c3VwZXInIg0KICBvaWQNCi0t LS0tLS0tDQogMjU4MzEzDQooMSByb3cpDQoNCiQNCiQgIyBkcm9wIHN1cGVyIHJvbGUNCiQgcHNx bCAtYyAiRFJPUCBST0xFIHRlc3RzdXBlciINCkRST1AgUk9MRQ0KJA0KJCAjIG9ic2VydmUgb2lk IHJlZmVyZW5jZSBpbiB0aGUgc2NyaXB0DQokIHBnX2R1bXAgLWQgZGIxIHwgZ3JlcCAnUkVWT0tF IEFMTCcNClJFVk9LRSBBTEwgT04gRlVOQ1RJT04gcHVibGljLnBnX2J1ZmZlcmNhY2hlX3BhZ2Vz KCkgRlJPTSAiMjU4MzEzIjsNClJFVk9LRSBBTEwgT04gRlVOQ1RJT04gcHVibGljLnBnX2J1ZmZl cmNhY2hlX3BhZ2VzKCkgRlJPTSBwZ19tb25pdG9yOw0KUkVWT0tFIEFMTCBPTiBUQUJMRSBwdWJs aWMucGdfYnVmZmVyY2FjaGUgRlJPTSAiMjU4MzEzIjsNCiQNCiQgIyBjbGVhbnVwDQokIHBzcWwg PDwgRU9GDQo+IERST1AgREFUQUJBU0UgSUYgRVhJU1RTIGRiMTsNCj4gRFJPUCBST0xFIElGIEVY SVNUUyB0ZXN0dXNlcjsNCj4gRFJPUCBST0xFIElGIEVYSVNUUyB0ZXN0c3VwZXI7DQo+IEVPRg0K RFJPUCBEQVRBQkFTRQ0KRFJPUCBST0xFDQpOT1RJQ0U6ICByb2xlICJ0ZXN0c3VwZXIiIGRvZXMg bm90IGV4aXN0LCBza2lwcGluZw0KRFJPUCBST0xFCgo= --===============3835385111754708654==--