[postgis-users] postgis install problems

[Dowling, James Parker]

Brent,

Thank you for your response.

I generated the database using a template containing plpgsql.  When I attempt to run the createlang statement, I receive an error stating that it already exists, so I think I'm good there.

/opt/PostgreSQL/8.3/lib/postgresql/liblwgeom.so does exist as a link (as well as liblwgeom.so.1) pointing to file liblwgeom.so.1.3 in the same directory.  The file and links are owned by root.  Permissions on the link are open to the world and are executable by postgres.  They all had the timestamp of the postgis install.

I ran /sbin/ldconfig -v after adding the lib path to /etc/ld.so.conf.  I did noticed that liblwgeom.so.1 appeared in the verbose output, while liblwgeom.so did not, though its timestamp was updated.

Still no joy. Any other ideas?

Thanks,
Jim



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of pcreso at pcreso.com
Sent: Friday, September 05, 2008 5:52 PM
To: PostGIS Users Discussion; dowling at iupui.edu
Subject: Re: [postgis-users] postgis install problems

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
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users