This is the version for the target ubuntu database: django=# select postgis_lib_version(); postgis_lib_version --------------------- 1.3.3 (1 row)
And Windows is 1.3.6. So I think you're exactly right! Thanks for your help. --- On Fri, 7/10/09, Paul Ramsey <[email protected]> wrote: > From: Paul Ramsey <[email protected]> > Subject: Re: [postgis-users] problems restoring dumps due to _st_dwithin > To: "PostGIS Users Discussion" <[email protected]> > Date: Friday, July 10, 2009, 10:02 AM > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
