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

[Jeff Hamann]

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?





-------------- next part --------------
A non-text attachment was scrubbed...
Name: jeff_hamann.vcf
Type: text/x-vcard
Size: 284 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090316/c1c1210b/attachment.vcf>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 258 bytes
Desc: OpenPGP digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090316/c1c1210b/attachment.pgp>