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
