Re: template0 and template1 databases

Thanks for the info and link.

So if I'm running PostgreSQL 7.1.3 and have pg_dumped
my databases, I can 'dropdb template0'?

Andrew

--- "J.H.M. Dassen (Ray)" <jdassen(at)cistron(dot)nl> wrote:
> Andrew Gould <andrewgould(at)yahoo(dot)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
>
> 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(at)postgresql(dot)org)

__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com