Re: Simpler dump?

Thanks All.  I learned plenty this morning.
--- Douglas McNaught <doug@mcnaught.org> wrote:

> On 12/10/07, Ted Byers <r.ted.byers@rogers.com>
> wrote:
>
> > OK.  A worry.  How is template_postgis
> constructed?
> > Is it just a handy reference to template1?  Or
> does it
> > exist independantly?  I don't want to be dropping
> > template1 only to find that breaking
> template_postgis.
>
> All databases are separate entities--the data copy
> only happens at
> creation time, based on the template you specify.
> The
> 'template_postgis' DB is not a standard PG database,
> so either it's
> created by the PostGIS install, or someone at your
> site set it up.
>
> It sounds like the thing for you to do is drop
> template1 (which will
> have no effect on template_postgis), create it again
> from template0,
> and use template_postgis when you need it (otherwise
> template1 will be
> used by default for new databases).
>
Great!  Thanks for this.  I appreciate it.

Ted