6

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

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

1 Answer 1

Reset to default
2

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.

Improve this answer
1
  • Ok, thanks for the answer. Though I have went through hard upgrade already:].
    – pajton
    Commented May 31, 2012 at 14:42

Your Answer

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

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