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)?

  • 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

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.

  • Ok, thanks for the answer. Though I have went through hard upgrade already:]. – pajton May 31 '12 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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