[postgis-tickets] [PostGIS] #2680: In place major version upgrade

[PostGIS]

#2680: In place major version upgrade
-------------------------+--------------------------------------------------
 Reporter:  jordanhagan  |       Owner:  pramsey       
     Type:  enhancement  |      Status:  new           
 Priority:  medium       |   Milestone:  PostGIS Future
Component:  postgis      |     Version:  2.1.x         
 Keywords:               |  
-------------------------+--------------------------------------------------
 I'm currently working through upgrading a PostgreSQL 9.0 instance to 9.2
 along with PostGIS 1.5.2 -> 2.0.2.

 Our database is about 2TB in size, so a dump/import upgrade is not
 feasible for us. Fortunately, only a small portion of our data (5%) is
 geospatial, so I've been able to put together a procedure where I strip
 out the geospatial data, uninstall postgis, perform an in place pg_upgrade
 and then merge the data back in again.

 It would be great however if there was a upgrade path available without
 having to dump/import, as in the future as our geospatial data grows this
 current procedure will become less and less viable.

 I found the following discussion in the mailing list about this issue:

 http://marc.info/?l=postgis-devel&m=130592806207086&w=2

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