Geek Answers Handbook

No liblwgeom when using postgresql84 and postgis on Snow Leopard with MacPorts

I am trying to restore a backup of my dev environment and run it after upgrading to Snow Leopard. In particular, I need postgresql and postgis, but I ran into the following problem.

After setting both parameters with the following:

sudo port install postgresql84 postgresql84-server postgis

I get errors like the following when I try to load my sql database which has links to liblwgeom.so

 ERROR: function public.box3d_in(cstring) does not exist ERROR: incompatible library "/usr/local/pgsql/lib/liblwgeom.so": version mismatch DETAIL: Server is version 8.4, library is version 8.3.

This file exists on my computer, but it should sit next to the old postgresql 8.3 installation. The problem is that I cannot figure out where liblwgeom.so should come from. It is not included in postgis 1.4, and a google search leaves me scratching my head. Any ideas?

+4
source share
2 answers

liblwgeom.so ships with PostGIS vesion 1.3. It has been renamed 1.4. It looks like your dump has a database with PostGIS 1.3, and you are trying to restart PostGIS 1.4. This is not supported.

For more information on what to do, see the PostGIS upgrading manual .

+5
source

Update ports:

 sudo port selfupdate

Then install postgis 1.4 which will work for postgresql 8.4

 sudo port install postgis
+1
source

More articles:


All Articles