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 1mSXxs-0000oO-OE for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Sep 2021 05:05:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mSXxr-00024V-Ne for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Sep 2021 05:05:07 +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 1mSXxr-00024M-CK for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 05:05:07 +0000 Received: from forward500o.mail.yandex.net ([2a02:6b8:0:1a2d::610]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mSXxn-0004F4-P5 for pgsql-bugs@lists.postgresql.org; Tue, 21 Sep 2021 05:05:06 +0000 Received: from vla3-a1a926cfe7da.qloud-c.yandex.net (vla3-a1a926cfe7da.qloud-c.yandex.net [IPv6:2a02:6b8:c15:2591:0:640:a1a9:26cf]) by forward500o.mail.yandex.net (Yandex) with ESMTP id 4355C941C02; Tue, 21 Sep 2021 08:04:59 +0300 (MSK) Received: from 2a02:6b8:c0d:328e:0:640:cb4f:aa91 (2a02:6b8:c0d:328e:0:640:cb4f:aa91 [2a02:6b8:c0d:328e:0:640:cb4f:aa91]) by vla3-a1a926cfe7da.qloud-c.yandex.net (mxback/Yandex) with HTTP id v4VBvd5DCSw1-4wD0o2BG; Tue, 21 Sep 2021 08:04:58 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1632200698; bh=hBxPbGPq5aH6TJxGAQABb7FbmSFIZasthI6VvC5wxcY=; h=Message-Id:Cc:Subject:In-Reply-To:Date:References:To:From; b=l/EoC0WBr8nMYa4O4awXUElwwNNBnT5sOs1Xmlu6kQ6xUOtcESwoYZpJ4ewy6nqoH Azz9y0ZIL6RbC14ppPSb9fyhqYT6WUcsTPKc5mjdB/CNSRyjlBJWnu80p7dqayz7LM Hn+AX1VfFJ49XvUW8AeTze02gL7t1xNnyWfiSv/U= Authentication-Results: vla3-a1a926cfe7da.qloud-c.yandex.net; dkim=pass header.i=@yandex.ru Received: by vla1-cb4faa915938.qloud-c.yandex.net with HTTP; Tue, 21 Sep 2021 08:04:58 +0300 From: Boris P. Korzun Envelope-From: drtr0jan@yandex.ru To: Neil Chen Cc: "pgsql-bugs@lists.postgresql.org" In-Reply-To: References: Subject: Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Tue, 21 Sep 2021 08:04:58 +0300 Message-Id: <8261632200581@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj5IaSBOZWlsLDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PndoYXQgYWJvdXQgdGhlIGNvbW1p dCB0byB0aGUgdXBzdHJlYW0/PC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+MzEuMDMuMjAyMSwgMDY6 MDIsICJOZWlsIENoZW4iICZsdDtjYXJwZW50ZXIubmFpbC5jekBnbWFpbC5jb20mZ3Q7OjwvZGl2 PjxibG9ja3F1b3RlPjxkaXY+R3JlZXRpbmdzLDxkaXY+wqA8L2Rpdj48ZGl2PkkgZGlkIHNvbWUg cmVzZWFyY2ggb24gdGhpcyBidWcgYW5kIGZvdW5kIHRoYXQgdGhlIHJlYXNvbiBmb3IgdGhlIHBy b2JsZW0gaXPCoHRoYXQgdGhlIHBnX2R1bXAgbWlzanVkZ2VkIHRoZSBub24tZ2xvYmFsIGRlZmF1 bHQgYWNjZXNzIHByaXZpbGVnZXMgd2hlbiBleHBvcnRpbmcuwqBUaGUgZGV0YWlscyBhcmUgYXMg Zm9sbG93czo8L2Rpdj48YmxvY2txdW90ZT5UaGUgZGVmYXVsdCBmb3IgYSBnbG9iYWwgZW50cnkg aXMgdGhlIGhhcmQtd2lyZWQgZGVmYXVsdCBBQ0wgZm9yIHRoZTxiciAvPnBhcnRpY3VsYXIgb2Jq ZWN0IHR5cGUuwqAgVGhlIGRlZmF1bHQgZm9yIG5vbi1nbG9iYWwgZW50cmllcyBpcyBhbiBlbXB0 eTxiciAvPkFDTC7CoCBUaGlzIG11c3QgYmUgc28gYmVjYXVzZSBnbG9iYWwgZW50cmllcyByZXBs YWNlIHRoZSBoYXJkLXdpcmVkPGJyIC8+ZGVmYXVsdHMsIHdoaWxlIG90aGVycyBhcmUgYWRkZWQg b24uPC9ibG9ja3F1b3RlPjxkaXY+V2UgY2FuIGZpbmQgdGhpcyBkZXNjcmlwdGlvbiBpbiBjb2Rl IGNvbW1lbnRzKHNyYy9iYWNrZW5kL2NhdGFsb2cvYWNsY2hrLmM6MTE2MikuIEZvcsKgZXhhbXBs ZSwgaWYgd2UgbG9nIGFzIHVzZXIgcG9zdGdyZXMsIGZvciBnbG9iYWwgZW50aXJlIG91ciBkZWZh dWx0IEFDTCBpcyAiez1YL3Bvc3RncmVzLHBvc3RncmVzPVgvcG9zdGdyZXN9IiwgZm9yIG5vbi1n bG9iYWwgZW50aXJlIGl0J3MgIk5VTEwiLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2Pk5vdyBsZXQn cyBsb29rIGF0IGEgcGFydCBvZiB0aGUgU1FMIHN0YXRlbWVudCB1c2VkIHdoZW4gcGdfZHVtcCBl eHBvcnRzIHRoZSBkZWZhdWx0IEFDTChpdCBjYW4gYmUgZm91bmQgaW4gc3JjL2Jpbi9wZ19kdW1w L2R1bXB1dGlscy5jOjc2Mik6PC9kaXY+PGJsb2NrcXVvdGU+KFNFTEVDVCBwZ19jYXRhbG9nLmFy cmF5X2FnZyhhY2wgT1JERVIgQlkgcm93X24pIEZST008YnIgLz4oU0VMRUNUIGFjbCwgcm93X24g RlJPTTxiciAvPnBnX2NhdGFsb2cudW5uZXN0KGNvYWxlc2NlKGRlZmFjbGFjbCxwZ19jYXRhbG9n LmFjbGRlZmF1bHQoQ0FTRSBXSEVOIGRlZmFjbG9ianR5cGUgPSAnUycgVEhFTiAncycgRUxTRSBk ZWZhY2xvYmp0eXBlIEVORDo6ImNoYXIiLGRlZmFjbHJvbGUpKSk8YnIgLz5XSVRIIE9SRElOQUxJ VFkgQVMgcGVybShhY2wscm93X24pPGJyIC8+V0hFUkUgTk9UIEVYSVNUUyAoPGJyIC8+U0VMRUNU IDEgRlJPTTxiciAvPnBnX2NhdGFsb2cudW5uZXN0KGNvYWxlc2NlKHBpcC5pbml0cHJpdnMscGdf Y2F0YWxvZy5hY2xkZWZhdWx0KENBU0UgV0hFTiBkZWZhY2xvYmp0eXBlID0gJ1MnIFRIRU4gJ3Mn IEVMU0UgZGVmYWNsb2JqdHlwZSBFTkQ6OiJjaGFyIixkZWZhY2xyb2xlKSkpPGJyIC8+QVMgaW5p dChpbml0X2FjbCkgV0hFUkUgYWNsID0gaW5pdF9hY2wpKSBhcyBmb28pwqA8L2Jsb2NrcXVvdGU+ PGRpdj5JdCBjYW4gYmUgc2VlbiB0aGF0IHdoZW4gY29tcGFyaW5nIHRoZSBjaGFuZ2VzIG9mIGRl ZmF1bHQgQUNMLCBpdCBkb2VzIG5vdCBkaXN0aW5ndWlzaCBiZXR3ZWVuIGdsb2JhbCBhbmQgbm9u LWdsb2JhbCBkZWZhdWx0IEFDTC4gSXQgdXNlcyB7PVgvcG9zdGdyZXMscG9zdGdyZXM9WC9wb3N0 Z3Jlc30gYXMgdGhlIG5vbi1nbG9iYWwgZGVmYXVsdCBBQ0wgYnkgbWlzdGFrZSwgcmVzdWx0aW5n IGluIHRoZSBleHBvcnQgZXJyb3IuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+Q29tYmluZWQgd2l0 aCB0aGUgYWJvdmUgcmVzZWFyY2gsIEkgZ2F2ZSB0aGlzIHBhdGNoIHRvIGZpeCB0aGUgYnVnLsKg SGFja2VycyBjYW4gaGVscCB0byBzZWUgaWYgdGhpcyBtb2RpZmljYXRpb24gaXMgY29ycmVjdC4g SSdtIHN0dWR5aW5nIGhvdyB0byB3cml0ZSB0ZXN0IHNjcmlwdHMgZm9yIGl0Li4uPC9kaXY+PGRp dj7CoDwvZGl2PjxkaXY+VGhhbmtzLjwvZGl2PjxkaXY+wqA8L2Rpdj4tLTxkaXY+PGRpdj5UaGVy ZSBpcyBubyByb3lhbCByb2FkIHRvIGxlYXJuaW5nLjxkaXY+SGlnaEdvIFNvZnR3YXJlIENvLjwv ZGl2PjwvZGl2PjwvZGl2PjwvZGl2PjwvYmxvY2txdW90ZT48ZGl2Pi0tLTwvZGl2PjxkaXY+V0JS PC9kaXY+PGRpdj5Cb3JpczwvZGl2Pg==