[postgis-users] Problems after update to PostGis 2.0
obe at IVV-AACHEN.DE
Thu Apr 26 05:48:50 PDT 2012
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
> 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 ?
> | __/ | Delivering high quality PostGIS 2.0 !
> | / 2.0 | http://strk.keybit.net - http://vizzuality.com
More information about the postgis-users