agora inbox for pgsql-docs@postgresql.orghelp / color / mirror / Atom feed
[PATCH] No more virgins 1+ messages / 1 participants [nested] [flat]
* [PATCH] No more virgins @ 2019-11-08 13:09 Alvaro Herrera <alvherre@alvh.no-ip.org> 0 siblings, 0 replies; 1+ messages in thread From: Alvaro Herrera @ 2019-11-08 13:09 UTC (permalink / raw) --- doc/src/sgml/manage-ag.sgml | 5 +++-- doc/src/sgml/ref/create_database.sgml | 2 +- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml index 0154064e50..a939ce8313 100644 --- a/doc/src/sgml/manage-ag.sgml +++ b/doc/src/sgml/manage-ag.sgml @@ -199,11 +199,12 @@ createdb -O <replaceable>rolename</replaceable> <replaceable>dbname</replaceable should never be changed after the database cluster has been initialized. By instructing <command>CREATE DATABASE</command> to copy <literal>template0</literal> instead - of <literal>template1</literal>, you can create a <quote>virgin</quote> user + of <literal>template1</literal>, you can create a user database that contains none of the site-local additions in <literal>template1</literal>. This is particularly handy when restoring a <literal>pg_dump</literal> dump: the dump script should be restored in a - virgin database to ensure that one recreates the correct contents + database without any user-defined objects, to ensure that one recreates + the correct contents of the dumped database, without conflicting with objects that might have been added to <literal>template1</literal> later on. </para> diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 4014f6703b..e56aca6d30 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -54,7 +54,7 @@ CREATE DATABASE <replaceable class="parameter">name</replaceable> system database <literal>template1</literal>. A different template can be specified by writing <literal>TEMPLATE <replaceable class="parameter">name</replaceable></literal>. In particular, - by writing <literal>TEMPLATE template0</literal>, you can create a virgin + by writing <literal>TEMPLATE template0</literal>, you can create a database containing only the standard objects predefined by your version of <productname>PostgreSQL</productname>. This is useful if you wish to avoid copying -- 2.20.1 --IS0zKkzwUGydFO0o-- ^ permalink raw reply [nested|flat] 1+ messages in thread
only message in thread Thread overview: 1+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-11-08 13:09 [PATCH] No more virgins Alvaro Herrera <alvherre@alvh.no-ip.org>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox