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 1mccLY-0003Qk-De for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Oct 2021 23:47:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mccLW-00036k-MV for pgsql-bugs@arkaria.postgresql.org; Mon, 18 Oct 2021 23:47:10 +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 1mccLW-00036b-Aa for pgsql-bugs@lists.postgresql.org; Mon, 18 Oct 2021 23:47:10 +0000 Received: from smtp-fw-6002.amazon.com ([52.95.49.90]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mccLU-0001Sk-7B for pgsql-bugs@lists.postgresql.org; Mon, 18 Oct 2021 23:47:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1634600829; x=1666136829; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=m6k8RhRVdZ6qdJo2I74QoaA0ENtaq3ERA9nPINoBndU=; b=CArtOwfbPDphQs8nMyEywOjC7OX39rOU03uhdvZErp3AykaWCF7AHPVC huD3bPp5vRe1F19ngOBpYZchMRr9YUYFZim8Gxnklwbh61zxOkhRvt6Ej a7X/A8QaAoDcddcZsHA4LxKrOdEWnTxFAar/Z0HcrwSPRwwc2EdEE5Bws k=; X-IronPort-AV: E=Sophos;i="5.85,382,1624320000"; d="scan'208";a="148634547" 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-iad-1d-54a073b7.us-east-1.amazon.com) ([10.43.8.2]) by smtp-border-fw-6002.iad6.amazon.com with ESMTP; 18 Oct 2021 23:47:00 +0000 Received: from EX13MTAUWB001.ant.amazon.com (iad12-ws-svc-p26-lb9-vlan3.iad.amazon.com [10.40.163.38]) by email-inbound-relay-iad-1d-54a073b7.us-east-1.amazon.com (Postfix) with ESMTPS id 6DCE6841B9; Mon, 18 Oct 2021 23:46:58 +0000 (UTC) Received: from EX13D03UWC003.ant.amazon.com (10.43.162.79) by EX13MTAUWB001.ant.amazon.com (10.43.161.249) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Mon, 18 Oct 2021 23:46:57 +0000 Received: from EX13D03UWC004.ant.amazon.com (10.43.162.49) by EX13D03UWC003.ant.amazon.com (10.43.162.79) with Microsoft SMTP Server (TLS) id 15.0.1497.24; Mon, 18 Oct 2021 23:46:57 +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; Mon, 18 Oct 2021 23:46:56 +0000 From: "Bossart, Nathan" To: Masahiko Sawada , Michael Paquier CC: Tom Lane , Neil Chen , "Boris P. Korzun" , "pgsql-bugs@lists.postgresql.org" Thread-Index: AQHXJdpJyJumIMh23Em/jNp/lMWaUKuvAL4AgAFWgACADvokgIATihaAgABQRQmAACmvAIABD36AgAXO5gA= Date: Mon, 18 Oct 2021 23:46:56 +0000 Message-ID: References: <8261632200581@mail.yandex.ru> <721942.1634180151@sss.pgh.pa.us> In-Reply-To: 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: <42EAA1B8DE459F45B412935FBD133360@amazon.com> Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk T24gMTAvMTQvMjEsIDU6MDYgUE0sICJNYXNhaGlrbyBTYXdhZGEiIDxzYXdhZGEubXNoa0BnbWFp bC5jb20+IHdyb3RlOg0KPiBUaGUgY3VycmVudCBwZ19kdW1wIHByb2R1Y2VkIGEgUkVWT0tFIEFM TCBPTiBUQUJMRVMgRlJPTQ0KPiByZWdyZXNzX2R1bXBfdGVzdF9yb2xlIGJ1dCBpdCBzZWVtcyB1 bm5lY2Vzc2FyeS4gVGhlIHBhdGNoIHJlbW92ZXMgaXQNCj4gc28gbG9va3MgZ29vZCB0byBtZSB0 b28uDQoNCisxDQoNCklmIHdlIGFyZSBnb2luZyB0byBwcm9jZWVkIHdpdGggdGhlIHBhdGNoIGlu IHRoaXMgdGhyZWFkLCBJIHRoaW5rIHdlDQpzaG91bGQgYWxzbyBtZW50aW9uIGluIHRoZSBjb21t ZW50IHRoYXQgd2UgYXJlIGRlcGVuZGluZyBvbg0KYWNsZGVmYXVsdCgpIGJlaW5nIFNUUklDVC4g IFRoaXMgcGF0Y2ggaXMgcXVpdGUgYSBiaXQgc21hbGxlciB0aGFuDQp3aGF0IEkgaGFkIHByb3Bv c2VkLCBidXQgQUZBSUNUIGl0IHByb2R1Y2VzIHRoZSBzYW1lIHJlc3VsdC4NCg0KTmF0aGFuDQoN Cg==