Re: template0 and template1 databases - Mailing list pgsql-general

From Tom Lane
Subject Re: template0 and template1 databases
Date
Msg-id 2395.999791400@sss.pgh.pa.us
Whole thread Raw
In response to Re: template0 and template1 databases  (Andrew Gould <andrewgould@yahoo.com>)
Responses Re: template0 and template1 databases
List pgsql-general
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: createdb buggy?
Next
From: "Jeff Eckermann"
Date:
Subject: Can a pl/perl function return NULL?