[postgis-users] Can't find postgis-1.4.so?

[Nathan Odgers]

All,

Disclaimer: I am new to PostgreSQL/PostGIS and am trying to make sense of it
all, so I ask for your patience.

I downloaded a copy of Postgre Plus Standard Server 8.4 from
enterprisedb.com. It is packaged with PostGIS 1.4. I am running OS X 10.5.8.

I was working through the basic PostGIS tutorial that enterprisedb provides
using pgAdmin3 entering SQL/pql code through the Terminal window.  This is
the demonstration code included in their tutorial, up to the point at which
I am getting stuck.

CREATE ROLE gisadmin PASSWORD 'mypassword'
LOGIN SUPERUSER
INHERIT CREATEDB;

CREATE DATABASE roadmaps
WITH OWNER = gisadmin
TEMPLATE = template_postgis;

\c roadmaps gisadmin;

CREATE TABLE roads (id INT4, name VARCHAR(128));

SELECT AddGeometryColumn('roads', 'geom', -1, 'GEOMETRY', 2);

INSERT INTO roads (id, geom, name)
VALUES (1, GeomFromText('LINESTRING(0 10,0 0)', -1), 'Beacon Road');

Everything seems to work fine until I enter the INSERT statement, after
which I get this error:

ERROR:  could not load library "/Library/PostgresPlus/8.4SS/lib/
postgis-1.4.so": dlopen(/Library/PostgresPlus/8.4SS/lib/postgis-1.4.so, 10):
Library not loaded:
/Users/buildfarm/pginstaller/PostGIS/caching/osx/proj-4.6.1.osx/lib/libproj.0.dylib
  Referenced from: /Library/PostgresPlus/8.4SS/lib/postgis-1.4.so
  Reason: image not found
CONTEXT:  SQL function "geomfromtext" statement 1

I decided to try and inspect the PostGIS settings and see if I could see
what was wrong. However, when I connect to the template_postgis database and
enter select postgis_full_version(), I get a similar error:

ERROR:  could not load library "/Library/PostgresPlus/8.4SS/lib/
postgis-1.4.so": dlopen(/Library/PostgresPlus/8.4SS/lib/postgis-1.4.so, 10):
Library not loaded:
/Users/buildfarm/pginstaller/PostGIS/caching/osx/proj-4.6.1.osx/lib/libproj.0.dylib
  Referenced from: /Library/PostgresPlus/8.4SS/lib/postgis-1.4.so
  Reason: image not found
CONTEXT:  SQL statement "SELECT postgis_lib_version()"
PL/pgSQL function "postgis_full_version" line 11 at SQL statement

Can anyone help me with this problem?

Regards,

Nathan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100823/384b1eba/attachment.html>