[postgis-users] PostGIS+FreeBSD 6.0 (AMD64) and Shared object "libpq.so.5" not found

[Paul Ramsey]

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/usr/local/pgsql/lib

p.

2009/3/16 Jeff Hamann <jeff.hamann at forestinformatics.com>:
> I apologize for the cross post, but I can't seem to get any traction on
> solving this problem. I'm a serious autoconf, automake, and libtool
> newbie, and I'm trying to get postgis up on a FreeBSD6.0-AMD64, and keep
> getting the following results when I gmake test in
> postgresql-8.3.5/contrib/postgis directory:
>
>
> $ gmake test
> gmake -C regress test
> gmake[1]: Entering directory
> `/usr/home/hamannj/postgresql-8.3.5/contrib/postgis/regress'
> cpp -P -traditional-cpp sql-mm-circularstring_expected.in | grep -v "^$"
>> sql-mm-circularstring_expected
> cpp -P -traditional-cpp sql-mm-compoundcurve_expected.in | grep -v "^$"
>> sql-mm-compoundcurve_expected
> cpp -P -traditional-cpp sql-mm-curvepoly_expected.in | grep -v "^$" >
> sql-mm-curvepoly_expected
> cpp -P -traditional-cpp sql-mm-multicurve_expected.in | grep -v "^$" >
> sql-mm-multicurve_expected
> cpp -P -traditional-cpp sql-mm-multisurface_expected.in | grep -v "^$" >
> sql-mm-multisurface_expected
> Creating spatial db postgis_reg
> TMPDIR is /tmp/pgis_reg_86134
>
>  PostgreSQL 8.3.5 on x86_64-unknown-freebsd6.0, compiled by GCC gcc
> (GCC) 3.4.4 [FreeBSD] 20050518
>  Postgis 1.3.5 - 2009-03-16 20:44:21
>   GEOS: 3.0.3-CAPI-1.4.2
>   PROJ: Rel. 4.6.1, 21 August 2008
>
> Running tests
>
>  loader/Point....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/PointM....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/PointZ....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/MultiPoint....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/MultiPointM....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/MultiPointZ....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/Arc....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/ArcM....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/ArcZ..... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/Polygon....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/PolygonM....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  loader/PolygonZ....... failed (dumping loaded table:
> /tmp/pgis_reg_86134/dumper.err)
>  regress. ok
>  regress_index. ok
>  regress_index_nulls. ok
>  lwgeom_regress. ok
>  regress_lrs. ok
>  removepoint. ok
>  setpoint. ok
>  simplify. ok
>  snaptogrid. ok
>  affine. ok
>  wkt. ok
>  measures. ok
>  long_xact. ok
>  ctors. ok
>  sql-mm-serialize. ok
>  sql-mm-circularstring. ok
>  sql-mm-compoundcurve. ok
>  sql-mm-curvepoly. ok
>  sql-mm-general. ok
>  sql-mm-multicurve. ok
>  sql-mm-multisurface. ok
>  geojson. ok
>  regress_ogc. ok
>  regress_bdpoly. ok
>  regress_ogc_cover. ok
>  regress_proj. ok
>  kml. ok
>
> Run tests: 39
> Failed: 12
> gmake[1]: Leaving directory
> `/usr/home/hamannj/postgresql-8.3.5/contrib/postgis/regress'
> $ cat /tmp/pgis_reg_86134/dumper.err
>
> results in the following:
>
> /libexec/ld-elf.so.1: Shared object "libpq.so.5" not found, required by
> "pgsql2shp"
>
> Is this because PostgreSQL was compiled using gcc 3.4.4 (old?)? Is this
> because there's some switch that's getting set in the makefile
> incorrectly. I keep seeing threads from 2005 when I search for, "Shared
> object "libpq.so.5" not found" and AMD64, but there doesn't seem to be a
> "just include the path that that shared library in your 'path'" solution
> and my libpq.so.5 is in /usr/local/pgsql/lib and being a unix sloth, I'm
> not sure how to get the OS/Makefile to 'see' the library and I don't
> know if this would be taken care of in the ./configure process...
>
> Does anyone have any suggestions?
>
>
>
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>