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

[Calum Byrom]

Hi Mark,

Thanks for the quick response.  I've tried what you suggested but to no
avail.  Observations whilst doing this:

i) If I install PostGIS from the unzipped source, via a ./configure, gmake,
sudo gmake install, the lwpostgis.sql, etc scripts get put in /usr/share and
contain unexpanded $libdir variables.  The liblwgeom files end up under
/usr/lib64/postgresql

ii) If I install PostGIS via the rpm, using the YaST2 GUI, the
lwpostgis.sql, etc scripts get put in /usr/share/postgis and the $libdir
variable they use is expanded to /usr/lib64 (although I don't think any
expansion is actually being done since the timestamp on these files is quite
old - so they're just being unpacked to this dir).  The liblwgeom files here
get unpacked this libdir - i.e. /usr/lib64

I've not done anything out of standard for any of the installs except for
configuring the postgres install using, LDFLAGS=-lstdc++ ./configure  - as
suggested in the setup guide I was following (see link in first mail).

Any other suggestions?

Thanks,

Calum.

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

> Calum Byrom wrote:
>
> > 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.
> >
>
>
> Hi Calum,
>
> Okay, looks like something is not quite right in your installation. For
> example, above it seems like liblwgeom.so has been installed under /usr/lib
> which is wrong - it should be installed in the postgresql lib directory
> which is typically under /usr/lib/pgsql/lib or /usr/lib/postgresql/lib. Did
> you pass in any non-standard parameters to configure?
>
> As a first course of action, I would try removing all liblwgeom files from
> /usr/lib64 and trying to run lwpostgis.sql again.
>
>
>
> 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/f8dab70c/attachment.html>