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
