[postgis-devel] [PostGIS] #1762: Provide an unpackaged from 1.5 script

PostGIS trac at osgeo.org
Sat Apr 7 09:12:10 PDT 2012


#1762: Provide an unpackaged from 1.5 script
-------------------------+--------------------------------------------------
 Reporter:  robe         |       Owner:  pramsey      
     Type:  enhancement  |      Status:  new          
 Priority:  medium       |   Milestone:  PostGIS 2.0.1
Component:  postgis      |     Version:  2.0.x        
 Keywords:               |  
-------------------------+--------------------------------------------------
 If someone is running 9.1 with 1.5, they can experience a fairly clean
 upgrade if their old 1.5 is repackaged as an extension.

 Then the upgrade process would be before they backup
 1)
 {{{
 CREATE EXTENSION postgis VERSION "1.5.x" FROM unpackaged;
 }}}
 2) run backup
 3) create a new database with:

 {{{
 CREATE EXTENSION postgis;
 }}}
 4) Execute legacy_minal.sql
 5) restore your backup on new db

 By packaging an unpackaged PostGIS 1.5 as an extension -- all the postgis
 functions, tables, views from old would be guaranteed not to come back and
 mess up a clean postgis 2.0 install and you can still experience a clean
 upgrade without perl.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1762>
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.


More information about the postgis-devel mailing list