template question . . .

* Peter E. Chen <pchen3@jhmi.edu> [011220 15:53]:

Hey All,

Can anyone tell me the difference between the template1 database and the
template0 database? When I create new databases should I always use
template0?

template0 is a virgin copy of the initdb template1 before any user
additions to template1. It is frozen, and used by the pg_dump scripts
to restore from.

As to whether to use it or not, depends on what is added to template1
in your environment, and what you need at create database time.

LER

Thanks.

Peter

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--
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