Hi Ted,
Ted Byers wrote:
> --- Tom Lane <tgl@sss.pgh.pa.us> 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