Thread: template question . . .

template question . . .

From
"Peter E. Chen"
Date:
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?

Thanks.

Peter


Re: template question . . .

From
Larry Rosenman
Date:
* 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