[postgis-devel] [PostGIS] #964: Support for PostgreSQL 9.1+ new Extensions model

[PostGIS]

#964: Support for PostgreSQL 9.1+ new Extensions model
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey       
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  postgis      |     Version:  trunk         
 Keywords:               |  
-------------------------+--------------------------------------------------
Description changed by robe:

Old description:

> Since this feature was partly created with us in mind, we should take
> advantage of it.  We might not get to it for PostGIS 2.0 though sicne I
> haven't looked at how much effort is involved.
>
> So with the new way people would be spatially enabling their PostgreSQL
> database with
>

> {{{
> CREATE EXTENSION postgis VERSION '2.0';
> }}}
>

> This will also result in cleaner backups and restores since from what I
> can gather there are provisions to not backup functions etc. with data.

New description:

 Since this feature was partly created with us in mind, we should take
 advantage of it.  We might not get to it for PostGIS 2.0 though sicne I
 haven't looked at how much effort is involved.

 So with the new way people would be spatially enabling their PostgreSQL
 database with


 {{{
 CREATE EXTENSION postgis VERSION '2.0';
 }}}


 This will also result in cleaner backups and restores since from what I
 can gather there are provisions to not backup functions etc. with data.

 This will make a bunch of other things easier.  People wanting to install
 in a postgis schema or migrate their existing to postgis schema.

 {{{
 ALTER EXTENSION postgis SET SCHEMA postgis;
 }}}

 And upgrading will be easier as well so to upgrade from an old 2.0.0 that
 wasn't packaged as an extension would be in theory as simple as.


 {{{
 CREATE EXTENSION postgis VERSION '2.0' FROM unpackaged;
 }}}

 Still unclear how our minor upgrade would work or if we would have to
 label our version VERSION '2.0.0' to allow people to upgrade easily.


 {{{
 ALTER EXTENSION postgis UPDATE TO '2.0.1'
 }}}

--

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/964#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.