Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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.

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

Your Answer


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.