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, 2012 at 10:33
  • It is 1.5.3 and I want to upgrade to 2.0.0
    – pajton
    May 25, 2012 at 11:57
  • 2
    PostGIS version != Postgres version
    – underdark
    May 25, 2012 at 12:10
  • Ahhh, sorry. It's Postgres 9.1.3
    – pajton
    May 25, 2012 at 13:08
  • make a backup of your data first then do the 'hard update' managed to update without issue.
    – Mapperz
    May 25, 2012 at 13:33

1 Answer 1


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, 2012 at 14:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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