Re: template0 and template1 databases
От | Jeff Eckermann |
---|---|
Тема | Re: template0 and template1 databases |
Дата | |
Msg-id | 01dd01c136ea$0c356e80$279c10ac@INTERNAL обсуждение исходный текст |
Ответ на | Re: template0 and template1 databases (Andrew Gould <andrewgould@yahoo.com>) |
Ответы |
Re: template0 and template1 databases
|
Список | pgsql-general |
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) > >
В списке pgsql-general по дате отправления: