[postgis-users] Problems after update to PostGis 2.0

[Sandro Santilli]

On Thu, Apr 26, 2012 at 09:44:01AM +0200, Felix Obermaier wrote:

> Unfortunatly the geometry part of the database was not recoverable.
> All types of backup failed because geometry columns could not be included.

Did you try re-installing postgis 1.5.x ?

> Here is what I did:
> - I had a database with postgis 1.5.2 installed, tried to run postgis_upgrade_20_minor.sql which failed.

Excellent. It should even fail with a clear message about why
it was wrong to try that and what to do instead (did it?).

> - Updated that database to postgis 1.5.3, which succeeded.

Good. How did you do that ? 

> - Re ran postgis_upgrade_20_minor.sql, which this time succeeded.

Ouch. This shouldn't have happened.
Could you please file a ticket for this ?

> IMHO the Installation/Upgrade documentation does not explicitly state
> that you have to do a backup/restore to update from postgis 1.5 or prior.

It's in the README file, under the section UPGRADING:

<< PostGIS provides a SOFT UPGRADE procedure for minor or bugfix releases,
and an HARD UPGRADE procedure for major releases. >>

Maybe it isn't clear how to distinguish a "minor or bugfix" release
from a "major" release ?

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'