Re: Simpler dump?

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: "Ted Byers" <r(dot)ted(dot)byers(at)rogers(dot)com>
Cc: "Richard Huxton" <dev(at)archonet(dot)com>, "Tino Wildenhain" <tino(at)wildenhain(dot)de>, "Uwe C(dot) Schroeder" <uwe(at)oss4u(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Simpler dump?
Date: 2007-12-10 16:39:21
Message-ID: 5ded07e00712100839q49cfe31aq52a6754e39ca4766@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/10/07, Ted Byers <r(dot)ted(dot)byers(at)rogers(dot)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).

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert Fitzpatrick 2007-12-10 16:53:56 Creating indexes
Previous Message Douglas McNaught 2007-12-10 16:26:41 Re: Simpler dump?