Re: template0 and template1 databases

Okay, so I don't need to pg_dump the template*
databases; and I should not dropdb them.

My scripts aren't anything to brag about; but I think
newbies (such as myself) may find them useful.  Who
reviews contributions for /contrib?

Andrew

--- Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Andrew Gould <andrewgould@yahoo.com> writes:
> > So if I'm running PostgreSQL 7.1.3 and have
> pg_dumped
> > my databases, I can 'dropdb template0'?
>
> That would be A Bad Move.  template0 is what
> pg_dumpall expects to use
> to build new databases.  See the discussion near the
> bottom of
>
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-createdatabase.html
> (possibly this should be duplicated somewhere in the
> Administrator's Guide).
>
>             regards, tom lane


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