Re: template0 and template1 databases

* J.H.M. Dassen (Ray) <jdassen@cistron.nl> [010906 07:48]:
> 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
>
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@postgresql.org)
>

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