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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 05, 2008 5:52 PM To: PostGIS Users Discussion; [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> wrote: > From: Dowling, James Parker <[EMAIL PROTECTED]> > Subject: [postgis-users] postgis install problems > To: "[email protected]" > <[email protected]> > 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: > > [EMAIL PROTECTED] postgis-1.3.3]# > PATH=$PATH:/opt/PostgreSQL/8.3/bin > [EMAIL PROTECTED] postgis-1.3.3]# export path > [EMAIL PROTECTED] 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 > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
