[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