Re: template0 and template1 databases - Mailing list pgsql-general

From J.H.M. Dassen (Ray)
Subject Re: template0 and template1 databases
Date
Msg-id slrn9per9v.1g4.jdassen@odin.cistron-office.nl
Whole thread Raw
In response to template0 and template1 databases  (Andrew Gould <andrewgould@yahoo.com>)
Responses Re: template0 and template1 databases
Re: template0 and template1 databases
List pgsql-general
Andrew Gould <andrewgould@yahoo.com> wrote:
> I notice that template0 can't be vacuumed; and that template1 gets
> vacuumed but has "no relations" per \d.
>
> What do these databases do?

template0 is probably a leftover you got from importing a dump from an older
version of PostgreSQL. template1 is the "master" database from which new
databases are cloned; see
http://www.postgresql.org/idocs/index.php?managing-databases.html#MANAGE-AG-CREATEDB

HTH,
Ray
--
"a infinite number of monkeys typing into GNU emacs would never make a good
program"
    .../linux/Documentation/CodingStyle

pgsql-general by date:

Previous
From: Andrew Gould
Date:
Subject: template0 and template1 databases
Next
From: Andrew Gould
Date:
Subject: Re: template0 and template1 databases