[postgis-devel] Re: PostGIS datastore creation

[strk at refractions.net]

My toughts on the subject:

I like the idea of providing other utilities for:

	- create the template_gis on an a database location
	- create a gis-enabled database

I don't think the template_gis creation should be done at install
time as a single postgresql installation can have multiple locations
(PGDATA) and you want more control on which one need template_gis
and which not. 

I don't think we should allow remote creation of the template_gis
as in addition to the .sql file we also need to know the location
of the shared object and the shared object *must* be there, so it's
cleaner if the command is run locally, and it is installed by the
same make rule that installed the shared object and thus know its
location.


--strk;

On Wed, Sep 20, 2006 at 07:09:51PM +0100, 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

-- 

 /"\    ASCII Ribbon Campaign
 \ /    Respect for low technology.
  X     Keep e-mail messages readable by any computer system.
 / \    Keep it ASCII.