Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group