[postgis-devel] [PostGIS] #1367: Provide a clear upgrade path to 2.0

[PostGIS]

#1367: Provide a clear upgrade path to 2.0
---------------------+------------------------------------------------------
 Reporter:  strk     |       Owner:  pramsey      
     Type:  task     |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 2.0.0
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by strk):

 With r8468 the postgis_restore.pl script also takes care of
 spatial_ref_sys by restoring all entries in dump with SRIDs not found in
 pre-existing spatial_ref_sys table, thus allowing you to decide which
 version of the core srid you want (you probably want the new ones).

 This means that step 2 in the first comment (spatially-enable new
 database) could now include sourcing spatial_ref_sys.sql w/out worrying
 about getting a zilion "duplicate primary key" errors at restore time.

 I guess all is left here is documenting the procedure and calling for
 test.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1367#comment:6>
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.