[DebianGIS-dev] Bug#499059: Bug#499059: upgrade breaks postgis-database

[Francesco P. Lovergine]

notfound 1.3.3-3
thanks

On Mon, Sep 15, 2008 at 10:02:29PM +0200, Andreas Barth wrote:
> Package: postgresql-8.3-postgis
> Version: 1.3.3-3
> Severity: important
> 
> Hi,
> 
> upon upgrade from postgresql-8.1 to 8.3 with
> pg_upgradecluster 8.1 main
> the postgis-database was totally broken.
> 
> In my case, it was only a dump of the openstreetmap-database of bavaria,
> so I recreated it and it works now. I however had to execute
> /usr/share/postgresql-8.3-postgis/lwpostgis.sql to get it running
> before I could use osm2pgsql again successfully.
> 
> I still have the original database around in case you would like to have
> a look at it.
> 

Andi

Did you see http://wiki.debian.org/DebianGis/UpdatingPostGIS ?

AFAIK you cannot safely upgrade from 8.1 to 8.3 because you started from
an old postgis installation, where #441794 was not fixed at the time.
I'm expecting much better situation from current 1.3.3-3 on due
to the dirty trick I implemented only recently. Also you should use
the postgis upgrade script. That will not ensure you can upgrade
safely from one pg version to another, anyway. That's due to
the possibility that the pg versions are not compatible each other.

Synthetically: postgis upgrades are known to be for brave hearts.

-- 
Francesco P. Lovergine