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

[Mark Cave-Ayland]

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