[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