From: David Johnston <polobo@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Re: looking for doc
Date: Tue, 18 Mar 2014 09:29:52 -0700 (PDT)
Message-ID: <1395160192965-5796620.post@n5.nabble.com> (raw)
In-Reply-To: <6C308A1FFB24664F8636F3B58ABEF84588719A7D@RED-INF-EXMB-P2.esri.com>
References: <6C308A1FFB24664F8636F3B58ABEF845887198E2@RED-INF-EXMB-P2.esri.com>
<CAB8KJ=iArO5sWtj6UB5WAdFQ09p8Zd-Hzd+i70DSOh6whS5TMQ@mail.gmail.com>
<6C308A1FFB24664F8636F3B58ABEF8458871991F@RED-INF-EXMB-P2.esri.com>
<1395095146819-5796459.post@n5.nabble.com>
<1395095583225-5796462.post@n5.nabble.com>
<6C308A1FFB24664F8636F3B58ABEF84588719A7D@RED-INF-EXMB-P2.esri.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
> David J,
> If the whole purpose of a template is to be a basis for an additional user
> database than what admi tasks are defined in template 1 and template 0
> does matter, because if template 0 would never be used as a db in it's own
> right, it's descendants would be.
> For instance:
> Template 0 does not contain the language encodings and collation settings
> specific to the os on which postgres is running template 1 does, so if you
> want to create a db with language settings other than what is in template
> 1 you would use template 0, and if template 0 does not contain "admin
> tasks" than it would have to be administered manually....
Vacuum is not defined "in" a database; it is a system operation that acts
"on" databases. It has been told that the database named "template0" is
special and to not waste time on it.
As with any database you can "ALTER DATABASE SET guc = 'value';" though
again you shouldn't do that for template0 and I'm not sure such changes are
copied to new databases if applied to template1.
Language and collation can both be overridden during database creation if
you want something different than what template1 uses.
If you want to continue this discussion please define "admin tasks" (or give
more examples) more completely. If the only thing you can come up with is
"vacuum" then just say "vacuum".
David J.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/looking-for-doc-tp5796445p5796620.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: polobo@yahoo.com
Subject: Re: looking for doc
In-Reply-To: <1395160192965-5796620.post@n5.nabble.com>
* 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