[postgis-users] problems restoring dumps due to _st_dwithin

[Steve Howell]

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 <pramsey at opengeo.org> wrote:

> From: Paul Ramsey <pramsey at opengeo.org>
> Subject: Re: [postgis-users] problems restoring dumps due to _st_dwithin
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> 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<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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>