Re: [DebianGIS] postgis trouble
At 13:40, mercoledì 05 ottobre 2005, F.Sluiter has probably written:
> Hi Paolo,
>
> There are several approaches to this problem (I ran into the same
> while upgrading).
>
> First: your database will work, it just cannot find the proper postgis
> library. What happened is that postgresql7.5 just changed the paths of most
> of the binaries, but none of them are replaced (it is still postgresql
> 7.4).
> It did not copy the postgis library to the correct path, so you have
> to do that manually.
> cp /usr/lib/postgresql/lib/libpostgis* /usr/lib/postgresql/7.4/lib/
>
> now postgresql can start and find your libraries again.
> /etc/init.d postgresql start
That worked beautifully.
From now on I suppose I should:
dump all from pg74+pgis09
upgrade to pgis10
restore to pg80.
I agree new packages should not be used in production; I'm just anxious to
have the (much faster and nicer) 1.0 instead of the oldish 0.9.
> Now, you can (manually) dump the original tables SEPARATELY (not the
> whole database!) and upload them in the new server.
Aah, that's ugly! It will take ages. I'll do some testing on our pg8 pigbox.
> Do follow the
> guidelines in the postgis documentation and DO NOT attempt this
> automatically with scripts etc. I did, and it didn't work (yet). The
> new postgis packages might solve this in the future, but you should
> not use it in a production environment yet.
> The main thing is that some of the datatypes and functions changed, so
> the libraries are not binary compatible and the functionlist/datatypes
> will not migrate properly.
>
> Hopefully Alex (with a little help from us) can solve this
> updating/migrating very soon...
Looking forward to it.
pc
--
Paolo Cavallini
cavallini@faunalia.it cavallini@jabber.org www.faunalia.it
Piazza Garibaldi 5 - 56025 Pontedera (PI), Italy Tel: (+39)348-3801953
Reply to: