Re: template0 and template1 databases

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