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.santi...@gmail.com] Im Auftrag von > Sandro Santilli > Gesendet: Donnerstag, 26. April 2012 11:20 > An: Felix Obermaier > Cc: postgis-users@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------' _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
