Skip site navigation (1)Skip section navigation (2)
Date:      Mon, 16 Mar 2009 14:14:34 -0700
From:      Jeff Hamann <jeff.hamann@forestinformatics.com>
To:        postgis-users@postgis.refractions.net, freebsd-amd64@freebsd.org
Subject:   PostGIS+FreeBSD 6.0 (AMD64) and Shared object "libpq.so.5" not found
Message-ID:  <49BEC13A.1000401@forestinformatics.com>

next in thread | raw e-mail | index | archive | help
This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigB28B091E1E63D6E301E8C207
Content-Type: multipart/mixed; boundary="------------080008020301050309020802"

This is a multi-part message in MIME format.
--------------080008020301050309020802
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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?






--------------080008020301050309020802--

--------------enigB28B091E1E63D6E301E8C207
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.10 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAkm+wT4ACgkQeUshGa857GyhpQCeKDev1L7+0UwEq3cwSCwwUFCr
WicAn0J/T8ErSD2AFMUgVcR4ALdXOeq4
=UkRX
-----END PGP SIGNATURE-----

--------------enigB28B091E1E63D6E301E8C207--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?49BEC13A.1000401>