Re: template0 and template1 databases

Thanks!

Andrew

--- Jeff Eckermann <jeckermann@verio.net> wrote:
> 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)
> >
> >
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl


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