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 1jkgWU-0001uZ-W7 for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jun 2020 04:15:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jkgWS-0006CL-US for pgsql-hackers@arkaria.postgresql.org; Mon, 15 Jun 2020 04:15:00 +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 1jkgWS-0006CE-OE for pgsql-hackers@lists.postgresql.org; Mon, 15 Jun 2020 04:15:00 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jkgWQ-0003uW-JU for pgsql-hackers@postgresql.org; Mon, 15 Jun 2020 04:15:00 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 05F4EtfL1095908; Mon, 15 Jun 2020 00:14:55 -0400 From: Tom Lane To: Bruce Momjian cc: Joseph Nahmias , PostgreSQL-development Subject: Re: create database with template doesn't copy database ACL In-reply-to: <20200615033934.GB12121@momjian.us> References: <159136749445.7029.12571169059565185790@wrigleys.postgresql.org> <20200612212951.GB6813@momjian.us> <20200614072613.GA21852@nahmias.net> <20200615031102.GA12121@momjian.us> <1092722.1592191496@sss.pgh.pa.us> <20200615033934.GB12121@momjian.us> Comments: In-reply-to Bruce Momjian message dated "Sun, 14 Jun 2020 23:39:34 -0400" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <1095906.1592194495.1@sss.pgh.pa.us> Date: Mon, 15 Jun 2020 00:14:55 -0400 Message-ID: <1095907.1592194495@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Bruce Momjian writes: > Well, I thought we copied everything except things tha can be specified > as different in CREATE DATABASE, though I can see why we would not copy > them. Should we document this or issue a notice about not copying > non-default database attributes? We do not need a notice for behavior that (a) has stood for twenty years or so, and (b) is considerably less broken than any alternative would be. If you feel the docs need improvement, have at that. regards, tom lane