[postgis-users] problems restoring dumps due to _st_dwithin

Steve Howell showell30 at yahoo.com
Fri Jul 10 09:43:55 PDT 2009


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?





More information about the postgis-users mailing list