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
