[postgis-users] Restore data from Mac to Windows fails

[TECHER David]

Hi Barrend

When I do a backup from Windows to my laptop on Linux, I'm used to do on
my laptop before "backuping"

cp /usr/local/pgsql/lib/liblwgeom.1.1.so /usr/local/pgsql/lib/liblwgeom.dll

and it works :-)

So from Mac to Windows

on windows, i think you need to copy liblwgeom.dll to liblwgeom.1.1.so

copy c:\PostgreSQL\...\liblwgeom.dll C:\liblwgeom.1.1.so

But I don't know if it works!

-- 
--david;
http://www.davidgis.fr



Barend Köbben a écrit :

>Hi,
>
>I am trying to restore a database backup up from the Mac-version of PostgreSQL8.1.4+PostGIS1.1.1 to a Windows server installation (same versions),  first by using PGadminII, then by following the pg_dump-pg_restore story in the Postgres manual. I have try many (combinations of) settings, compress, tar, plain, with and without blobs, etc... 
>
>It fails. I first thought it was a general Postgres thing, but it seems the culprit is a PostGIS function, looking at the error message that always comes up :
>
>pg_restore: creating FUNCTION box2d_in(cstring)
>pg_restore: [archiver (db)] Error while PROCESSING TOC:
>pg_restore: [archiver (db)] Error from TOC entry 19; 1255 52517 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...
>
>The only workaround  I could find was backuing up the schema and data seperately as SQL inserts, then deleting the PostGIS function part from the schema SQL , and running bot in psql... Not very nice. 
>
>Has anybody an idea how to solve it?
>
>PS: I noticed that what the Mac version of PGadminIII calls ENCODING=UNICODE, the Win version calls ENCODING=UTF8. Surely this is just a naming problem, not  the cause...?
>--
>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
> 
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>



	

	
		
___________________________________________________________________________ 
Yahoo! Mail réinvente le mail ! Découvrez le nouveau Yahoo! Mail et son interface révolutionnaire.
http://fr.mail.yahoo.com