Re: template question . . .

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
Cc: "Postgres (General)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: template question . . .
Date: 2001-12-20 22:19:00
Message-ID: 20011220221900.GA1082@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* Peter E. Chen <pchen3(at)jhmi(dot)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(at)postgresql(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2001-12-20 22:47:22 Re: Security Question . . .
Previous Message Bruce Momjian 2001-12-20 22:00:57 Re: TOAST performance (was Re: [GENERAL] Delete Performance)