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

Jeff Hamann jeff.hamann at forestinformatics.com
Mon Mar 16 14:14:34 PDT 2009

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
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 "^$" >
cpp -P -traditional-cpp sql-mm-multicurve_expected.in | grep -v "^$" >
cpp -P -traditional-cpp sql-mm-multisurface_expected.in | grep -v "^$" >
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:
 loader/PointM....... failed (dumping loaded table:
 loader/PointZ....... failed (dumping loaded table:
 loader/MultiPoint....... failed (dumping loaded table:
 loader/MultiPointM....... failed (dumping loaded table:
 loader/MultiPointZ....... failed (dumping loaded table:
 loader/Arc....... failed (dumping loaded table:
 loader/ArcM....... failed (dumping loaded table:
 loader/ArcZ..... failed (dumping loaded table:
 loader/Polygon....... failed (dumping loaded table:
 loader/PolygonM....... failed (dumping loaded table:
 loader/PolygonZ....... failed (dumping loaded table:
 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
$ 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

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>

More information about the postgis-users mailing list