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

[Rick]

Not sure about BSD, I imagine it is the same, but on Linux you have to
run ldconfig to update the libraries.

Also, there is a way to tell ldconfig where to look, which can vary
from system to system.  look in /etc for ld.so.conf or ld.so.conf.d/
which would be a directory containg files to be parsed.

'man ldconfig' might help you as well, see the files section at the end.

Also, there is an option to get ldconfig to tell you what libraries it
sees and where it looks.  Again, read the man page.

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
>
>



-- 
Cheers!
Rick