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 _______________________________________________ Pkg-grass-devel mailing list Pkg-grass-devel@lists.alioth.debian.org http://lists.alioth.debian.org/mailman/listinfo/pkg-grass-devel