[postgis-users] problems restoring dumps due to _st_dwithin

Paul Ramsey pramsey at opengeo.org
Fri Jul 10 10:02:42 PDT 2009


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<showell30 at yahoo.com> 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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list