[postgis-users] PostGIS install on postgres 8.3 running on 64bit OpenSuse10.3

[Calum Byrom]

Hi,

Thankyou Facundo, for providing the links to the various rpms - I've used
these via yast2 to upgrade everything from 8.2 to 8.3 + installed proj, geos
and postgis using these.  I'm still getting the, same error when I run
lwpostgis.sql - i.e.:

psql:lwpostgis.sql:44: NOTICE:  type "histogram2d" is not yet defined
DETAIL:  Creating a shell type definition.
psql:lwpostgis.sql:44: ERROR:  incompatible library
"/usr/lib64/liblwgeom.so.1.3": version mismatch
DETAIL:  Server is version 8.3, library is version 8.2.

- this suggests to me that you might be right, Mark.  I'm not sure how to
check, however, what postgres install has been picked up by ./configure - I
can't spot anything in the output from the make file - it does display
DUSEVERSION=83 which I think means its using the proper version.  Is there
anything else I can check.  NB, not sure if its important but when I run the
build of postgis, I get the following warnings:

lwgeom_geos_c.c: In function 'GEOS2LWGEOM':
lwgeom_geos_c.c:2994: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3003: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3013: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3014: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3018: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3019: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c:3040: warning: assignment discards qualifiers from pointer
target type
lwgeom_geos_c.c: In function 'polygonize_garray':
lwgeom_geos_c.c:3404: warning: passing argument 1 of 'GEOSPolygonize' from
incompatible pointer type
lwgeom_geos_c.c: In function 'LWGEOM_buildarea':
lwgeom_geos_c.c:3554: warning: passing argument 1 of 'GEOSPolygonize' from
incompatible pointer type
lwgeom_geos_c.c:3597: warning: assignment discards qualifiers from pointer
target type
lwgeom_transform.c:207: warning: initialization from incompatible pointer
type
lwgeom_chip.c: In function 'CHIP_in':
lwgeom_chip.c:128: warning: format '%d' expects type 'int', but argument 4
has type 'long unsigned int'
shpopen.c:176: warning: 'rcsid' defined but not used
dbfopen.c:206: warning: 'rcsid' defined but not used


Thanks,

Calum.


On Fri, May 2, 2008 at 9:34 AM, Mark Cave-Ayland <
mark.cave-ayland at siriusit.co.uk> wrote:

> Calum Byrom wrote:
>
> > Hi,
> >
> > Has anyone managed to get PostGIS working on Postgres 8.3 running on
> > OpenSuse10.3 on 64bit hardware?
> >
> > I've gone through the install instructions described at:
> >
> >
> > http://liangzou.blogspot.com/2008/02/setting-up-postgresql-with-postgis-on.html
> >
> > and everything works ok until I get to the point of running:
> >
> > psql -d dgvbr -f lwpostgis.sql
> >
> > - this then throws up the error:
> >
> > BEGIN
> > psql:/home/cbyrom/postgis-1.3.3/lwpostgis.sql:44: NOTICE:  type
> > "histogram2d" is not yet defined
> > DETAIL:  Creating a shell type definition.
> > psql:/home/cbyrom/postgis-1.3.3/lwpostgis.sql:44: ERROR:  incompatible
> > library "/usr/lib64/postgresql/liblwgeom.so": versi
> > on mismatch
> > DETAIL:  Server is version 8.3, library is version 8.2.
> >
> >
> > I've downloaded and installed the latest versions of the required
> > software:
> >
> > postgresql-8.3.1
> > proj-4.6.0
> > geos-3.0.0
> > postgis-1.3.3
> >
> > - I've also retried with postgresql 8.2 - just to check - and this works
> > ok with the above script.  Unfortunately, I need the tsvector functionality
> > that is provided by postgres 8.3.
> >
> > I can't see where this mismatch is coming in since it appears from other
> > distros that postgis should be ok on postgres 8.3.
> >
> > Anyone have an idea what might be going on here?
> >
> > Many thanks,
> >
> > Calum
> >
>
>
> Hi Calum,
>
> It sounds as if you have 2 PostgreSQL installations on your machine -
> perhaps one installed as packages, and one compiled by hand. And it seems
> the ./configure picked up the source headers for the wrong version...
>
>
>
> ATB,
>
> Mark.
>
> --
> Mark Cave-Ayland
> Sirius Corporation - The Open Source Experts
> http://www.siriusit.co.uk
> T: +44 870 608 0063
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080502/9984e19c/attachment.html>