[postgis-users] Updating to 1.2.0 on Win gives Linux error?
Barend K=?ISO-8859-1?B?9g==?=bben
kobben at itc.nl
Fri Jan 26 08:32:27 PST 2007
I am going crazy:
- I have one machine (pubnt03.itc.nl) running PostGiS 1.1.1 on PostGreSQL
8.1.4
- An newer one (localhost) running PostGiS 1.2.0 on PostGreSQL 8.2.1
- Both on Windows XP sp2.
I try to dump, from CMD line in the new machine, a spatial DB (rimapper) on
the old machine and restore it on the new machine. I get an error
complaining about a Linux Library (liblwgeom.1.1.so), which of course does
not exist since I am on WinXP (I have a "liblwgeom.dll")..?!
My dump cmd:
pg_dump -h pubnt03.itc.nl -U root -e -Fc -i -C -f test.backup rimapper
The restore cmd:
pg_restore -h localhost -U root -e -Fc -i -d postgres -C test.backup
The error message:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 13; 1255 44816 FUNCTION
box2d_in(cstring) root
pg_restore: [archiver (db)] could not execute query: ERROR: could not
access file "$libdir/liblwgeom.1.1.so": No such file or directory
Command was: CREATE FUNCTION box2d_in(cstring) RETURNS box2d
AS '$libdir/liblwgeom.1.1.so', 'BOX2DFLOAT4_in'
LANGUAGE c IMMUTABLE...
Can anybody shed some light on how to get this upgrade done...?
__
Barend Köbben
International Institute for Geo-information
Sciences and Earth Observation (ITC)
PO Box 6, 7500AA Enschede (The Netherlands)
ph: +31 (0)53 4874253; fax: +31 (0)53 4874335
More information about the postgis-users
mailing list