Re: template0 and template1 databases

* J.H.M. Dassen (Ray) <jdassen(at)cistron(dot)nl> [010906 07:48]:
> Andrew Gould <andrewgould(at)yahoo(dot)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
>
Nope. template0 is new with 7.1, and is a VIRGIN copy of template1
after an initdb, but before any user additions.

template0 is used for pg_dump create database commands.

> HTH,
> Ray
> --
> "a infinite number of monkeys typing into GNU emacs would never make a good
> program"
> .../linux/Documentation/CodingStyle
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749