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 1l0lH5-0001mI-Dx for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Jan 2021 13:05:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1l0lH4-0003LQ-BX for pgsql-hackers@arkaria.postgresql.org; Sat, 16 Jan 2021 13:05:50 +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 1l0lH4-0003LJ-4q for pgsql-hackers@lists.postgresql.org; Sat, 16 Jan 2021 13:05:50 +0000 Received: from relay5-d.mail.gandi.net ([217.70.183.197]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1l0lH1-0001tY-OQ for pgsql-hackers@postgresql.org; Sat, 16 Jan 2021 13:05:49 +0000 X-Originating-IP: 79.88.149.14 Received: from [172.16.255.146] (14.149.88.79.rev.sfr.net [79.88.149.14]) (Authenticated sender: vik@postgresfriends.org) by relay5-d.mail.gandi.net (Postfix) with ESMTPSA id E3E2A1C0007; Sat, 16 Jan 2021 13:05:43 +0000 (UTC) Subject: Re: Dump public schema ownership & seclabels To: Noah Misch , pgsql-hackers@postgresql.org References: <20201229134924.GA1431748@rfd.leadboat.com> <20201230115902.GB1431748@rfd.leadboat.com> From: Vik Fearing Message-ID: Date: Sat, 16 Jan 2021 14:05:43 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101 Thunderbird/68.10.0 MIME-Version: 1.0 In-Reply-To: <20201230115902.GB1431748@rfd.leadboat.com> Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 12/30/20 12:59 PM, Noah Misch wrote: > On Tue, Dec 29, 2020 at 05:49:24AM -0800, Noah Misch wrote: >> https://postgr.es/m/20201031163518.GB4039133@rfd.leadboat.com gave $SUBJECT as >> one of the constituent projects for changing the public schema default ACL. >> This ended up being simple. Attached. > > This is defective; it fails to reproduce nspacl after "ALTER SCHEMA public > OWNER TO pg_write_server_files; REVOKE ALL ON SCHEMA public FROM > pg_write_server_files;". I will try again later. Could I ask you to also include COMMENTs when you try again, please? -- Vik Fearing