No. "template0" is new for version 7.1. No doubt a developer can tell you
exactly why dropping "template0" would be a very bad idea; I am just getting
in quickly to make sure you don't do so in the interim :-)
----- Original Message -----
From: "Andrew Gould" <andrewgould@yahoo.com>
To: "J.H.M. Dassen (Ray)" <jdassen@cistron.nl>;
<pgsql-general@postgresql.org>
Sent: Thursday, September 06, 2001 7:51 AM
Subject: Re: [GENERAL] 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@cistron.nl> wrote:
> > Andrew Gould <andrewgould@yahoo.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@postgresql.org)
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo!
Messenger
> http://im.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
