[postgis-users] Problems after update to PostGis 2.0

[Felix Obermaier]

Trying to reproduce the steps I did to corrupt the postgis 1.5 database I noticed that I did the following:
- Opening SQL window from pgAdmin III
- Loading postgis_upgrade_20_minor.sql
- executing (F5) --> failed with warning.
- executing pgScript (F6) --> failed with invalid token 6,5:';'.
- comment out BEGIN; and COMMIT;
- executing pgScript (F6) --> succes

I suppose this is personal stupidity and not worth a ticket.


> -----Ursprüngliche Nachricht-----
> Von: Sandro Santilli [mailto:sandro.santilli at gmail.com] Im Auftrag von
> Sandro Santilli
> Gesendet: Donnerstag, 26. April 2012 11:20
> An: Felix Obermaier
> Cc: postgis-users at postgis.refractions.net
> Betreff: Re: [postgis-users] Problems after update to PostGis 2.0
> 
> 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------'