Re: template0 and template1 databases

Thanks, Tom!

The only things I've done to the template* databases
(intentionally) was vacuumdb and \d to template1.

Andrew

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Gould <andrewgould(at)yahoo(dot)com> writes:
> > Okay, so I don't need to pg_dump the template*
> > databases; and I should not dropdb them.
>
> template0 shouldn't need to be dumped, since it's
> always supposed to be
> virgin initdb data. template1 may need to be dumped
> if you have any
> site-local additions in it. pg_dumpall gets these
> considerations right.
>
> As for dropping, the system won't let you do it
> unless you go in and
> hand-hack pg_database's datistemplate flags. I have
> actually tested
> dropping template1 and recreating it from template0,
> which I suppose
> someone might want to do if they mess up template1
> badly enough.
> If you drop template0, you no longer have a
> guaranteed virgin database
> to use as a reference, but perhaps that doesn't
> bother you.
>
> > My scripts aren't anything to brag about; but I
> think
> > newbies (such as myself) may find them useful.
> Who
> > reviews contributions for /contrib?
>
> Send 'em to pgsql-patches, I guess.
>
> regards, tom lane

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