Hi Ted,
Ted Byers wrote:
--- Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
...
it's not pg_dump's fault --- you need to clean out
template1.
Thanks Tom,
Where will I find template1? When I look at the
databases on the server, the only template I see is
called "template_postgis". Most of the extra stuff I
see in all my databases relates to geometry that I
find in this template. When I installed postgresql, I
enabled postgis because I need it for some, but not
all, of my databases. Is it possible to have more
than one template, and to specify which template to
use when creating a new DB?
Yes thats possible - createdb has an option -T to
specify another template database.
Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
