You didn't mention your PostGIS versions. Given that your new instance seems to be missing an underlying C function, my guess is that your version on ubuntu is older than your version in windows.
P On Fri, Jul 10, 2009 at 9:43 AM, Steve Howell<[email protected]> wrote: > > Has anybody encountered a problem like this when doing pg_dump/pg_restore > between two different postgis databases? > > pg_restore: [archiver (db)] could not execute query: ERROR: could not find > function "LWGEOM_dwithin" in file "/usr/lib/postgresql/8.3/lib/liblwgeom.so" > Command was: CREATE FUNCTION _st_dwithin(geometry, geometry, double > precision) RETURNS boolean > AS '$libdir/liblwgeom', 'LWGEOM_dwithi.. > > I am copying from a Windows instance to a slightly newer ubuntu instance: > > PostgreSQL 8.3.5, compiled by Visual C++ build 1400 > (1 row) > > PostgreSQL 8.3.7 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real > (Ubuntu 4.3.3-5ubuntu4) 4.3.3 > (1 row) > > Did anything change with regard to _st_dwithin before those versions? If so, > does anybody have advice on working around compatibility issues? > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
