Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a PostGIS 1.5 database and want to update to 2.0. I read that because this is major release I have to follow the 'Hard update' procedure. However the spatial data I have is only test data so I can drop it.

If this is the case, is there easier procedure to update to 2.0 if I don't care about spatial data (I do care about non-spatial tables)?

share|improve this question
    
Which Postgres version are you running? –  underdark May 25 '12 at 10:33
    
It is 1.5.3 and I want to upgrade to 2.0.0 –  pajton May 25 '12 at 11:57
2  
PostGIS version != Postgres version –  underdark May 25 '12 at 12:10
    
Ahhh, sorry. It's Postgres 9.1.3 –  pajton May 25 '12 at 13:08
    
make a backup of your data first then do the 'hard update' managed to update without issue. –  Mapperz May 25 '12 at 13:33
show 1 more comment

1 Answer

If you don't care about losing your postgis geometry columns etc, you can run the uninstall_postgis.sql that is packaged with 1.5 (IT WILL DESTROY ALL POSTGIS DATA so be sure). Then you can install PostGIS 2.0 without needing to restore.

share|improve this answer
    
Ok, thanks for the answer. Though I have went through hard upgrade already:]. –  pajton May 31 '12 at 14:42
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.