[postgis-users] postgis install problems

[pcreso at pcreso.com]

Hi James,

You don't say whether you successfully installed plpgsql:

createlang plpgsql dbm_test

But I don't think failing to do this will cause the error you are reporting.

It looks like it is not picking up the postgis libraries.

Can you check that /opt/PostgreSQL/8.3/lib/postgresql/liblwgeom.so
exists, & if not, then where liblwgeom.so is on your system?

Move it to (or create a link to it at) that location if it is somewhere 
else & try again.

You can also use ldconfig (as root) to add the directory with the PostGIS library in it to the library (dynamic linker) search path, and add the PostGIS lib directory to /etc/ld.so.conf


HTH,

  Brent Wood


--- On Sat, 9/6/08, Dowling, James Parker <jdowling at iupui.edu> wrote:

> From: Dowling, James Parker <jdowling at iupui.edu>
> Subject: [postgis-users] postgis install problems
> To: "postgis-users at postgis.refractions.net" <postgis-users at postgis.refractions.net>
> Date: Saturday, September 6, 2008, 9:29 AM
> All,
> 
> I've installed the following with no apparent errors:
> 
> RHEL v 5 (Oracle's Build)
> PostgreSQL v 8.3.3 (EnterpriseDB)
> Proj4  v 4.4.8
> GEOS v 3.0.0
> PostGIS v 1.3.3
> 
> When I attempt to load lwpostgis.sql I run up against the
> following error:
> 
> [root at in-polis-lnx01 postgis-1.3.3]#
> PATH=$PATH:/opt/PostgreSQL/8.3/bin
> [root at in-polis-lnx01 postgis-1.3.3]# export path
> [root at in-polis-lnx01 postgis-1.3.3]# psql -d dbm_test -f
> lwpostgis.sql -U postgres -W
> Password for user postgres:
> BEGIN
> psql:lwpostgis.sql:44: NOTICE:  type
> "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:lwpostgis.sql:44: ERROR:  could not load library
> "/opt/PostgreSQL/8.3/lib/postgresql/liblwgeom.so":
> /opt/PostgreSQL/8.3/lib/postgresql/liblwgeom.so: undefined
> symbol: pj_set_searchpath
> psql:lwpostgis.sql:50: ERROR:  current transaction is
> aborted, commands ignored until end of transaction block
> psql:lwpostgis.sql:56: ERROR:  current transaction is
> aborted, commands ignored until end of transaction block
> ................
> 
> I'm brand new to PostgreSQL and pretty rusty with unix,
> any help would be appreciated.
> 
> Thanks,
> Jim
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users