[postgis-devel] Re: PostGIS datastore creation

[Paul Ramsey]

The main issue is, as Chris says, (a) that the template be created as 
part of a standard install and (b) that the name of the template be 
standard.

I like "template_postgis" just fine.

As far as the "create on install" part goes, you already have the option 
to create a spatial database in your PostGIS windows install, just add a 
non-optional creation of "template_postgis" to that.

Then, as you note, FDO can create a new spatial database purely with 
SQL: "CREATE DATABASE gisdb TEMPLATE=template_postgis"

Joy and dancing will be in the streets :)

Paul

Mark Cave-Ayland wrote:
> On Wed, 2006-09-20 at 10:13 -0700, Chris Hodgson wrote:
>> Greg and Mark, while I think your ideas certainly have merit, I don't 
>> think they address the main problem - the FDO client needs to be able to 
>> create a new database using ONLY the SQL connection to the server. The 
>> FDO client knows nothing of the Platform, OS, or even version of postgis 
>> that is installed on the server. We can't even use a standard postgis 
>> stored procedure on the postgres side because if we don't have a spatial 
>> database yet, none of the postgis stored procedures would be installed.
> 
> 
> Hi Chris,
> 
> The impression I got from Paul's email was that the main issue was how
> to create the template database as part of the install process rather
> than how the FDO client can create a new database. AFAIK it's already
> possible to create a database from a template using just an SQL
> connection by using something like "CREATE DATABASE gisdb
> TEMPLATE=template_postgis". Then again, it may be that I've
> misunderstood something since I've never used FDO?
> 
> 
> Kind regards,
> 
> Mark.
> 
> 
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel