From: Bruce Momjian <bruce@momjian.us>
To: david@kapitaltrading.com
To: pgsql-docs@lists.postgresql.org
Subject: Re: "22.3. Template Databases" documentation is incomplete
Date: Sat, 28 Oct 2023 12:18:50 -0400
Message-ID: <ZT00aqNUUQxhXHBo@momjian.us> (raw)
In-Reply-To: <166007719137.995877.13951579839074751714@wrigleys.postgresql.org>
References: <166007719137.995877.13951579839074751714@wrigleys.postgresql.org>
On Tue, Aug 9, 2022 at 08:33:11PM +0000, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/manage-ag-templatedbs.html
> Description:
>
> The documentation for creating databases from templates is incomplete, and
> should mention that access privileges are not copied. So, for example,
> issuing:
>
> create database newdb with template existingdb owner someuser;
>
> results in the newly-created database lacking the access privileges that
> exist in the template.
>
> cf: https://www.postgresql.org/docs/13/manage-ag-templatedbs.html
I have created the attached patch to document this.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
Attachments:
[text/x-diff] template.diff (721B, ../ZT00aqNUUQxhXHBo@momjian.us/2-template.diff)
download | inline diff:
[1mdiff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml[m
[1mindex 192c500994..b852783a6c 100644[m
[1m--- a/doc/src/sgml/manage-ag.sgml[m
[1m+++ b/doc/src/sgml/manage-ag.sgml[m
[36m@@ -210,7 +210,8 @@[m [mcreatedb -O <replaceable>rolename</replaceable> <replaceable>dbname</replaceable[m
objects in databases. For example, if you install the procedural[m
language <application>PL/Perl</application> in <literal>template1</literal>, it will[m
automatically be available in user databases without any extra[m
action being taken when those databases are created. [32mIt does not copy[m
[32m database-level <command>GRANT</command> permissions.[m
</para>[m
<para>[m
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: bruce@momjian.us, david@kapitaltrading.com, pgsql-docs@lists.postgresql.org
Subject: Re: "22.3. Template Databases" documentation is incomplete
In-Reply-To: <ZT00aqNUUQxhXHBo@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox