Leo & Regina:<br><br>You were right - I was having library link issues. I'd previously followed your tutorial (linked below) but was mis-reading the "ldd" outputs. Thank you.<br><br clear="all">--<br>Tom<br>
<br><div class="gmail_quote">On Sat, Oct 2, 2010 at 9:08 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Tom,<br>
<br>
Its unclear from your note if this is your problem, but from experience, the<br>
most common problem people run into when compiling PostGIS on Cent OS/Red<br>
Hat EL is the binding between the geos library linking and <a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a>.<br>
<br>
We documented a workaround here -<br>
<a href="http://www.postgresonline.com/journal/archives/147-Compiling-PostGIS-1.5-and%0A-installing-after-Yum-PostgreSQL-Install.html" target="_blank">http://www.postgresonline.com/journal/archives/147-Compiling-PostGIS-1.5-and<br>
-installing-after-Yum-PostgreSQL-Install.html</a><br>
-- way down in the problems section<br>
<br>
Basically you want to check to make sure the links are right by running<br>
ldd -d /usr/lib64/pgsql/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a><br>
ldd -d /usr/lib64/pgsql/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a> | grep libgeos<br>
ldd -d /usr/lib64/pgsql/<a href="http://postgis-1.5.so" target="_blank">postgis-1.5.so</a> | grep libproj<br>
<br>
And then correct them. We just change the symlinks to point to the right<br>
place -- which we have documented in the above article.<br>
<br>
I think Mark Cave-Ayland or Sandro Santilli had a more elegant way of fixing<br>
this issue, but can't find that item.<br>
If they are around, maybe they can chime in on this.<br>
<br>
We should probably note this in the installation and FAQ some where since<br>
it seems several people have been bitten by this.<br>
<br>
As a side note --with-pgsql is obsolete -- you should be using --<br>
--with-pgconfig=FILE (where FILE is path to your postgresql config)<br>
<br>
Leo and Regina<br>
<a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><br>
<br>
<br>
<br>
________________________________<br>
<br>
From: <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a><br>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a>] On Behalf Of Tom<br>
Liebert<br>
Sent: Friday, October 01, 2010 1:02 PM<br>
To: postgis-users<br>
Subject: [postgis-users] Trouble Installing PostGIS 1.5.2 on Enterprise<br>
Linux<br>
<div><div></div><div class="h5"><br>
<br>
I've got some experience installing PostGIS on Postgres 8.4 running on<br>
Ubuntu Linux, but am running into issues on CentOS 5.5. I've got all<br>
dependencies installed: Geos-3.2.2, Proj-4.7.0, GDAL/OGR 1.7.2 (!),<br>
libxml2-2.7.6 and everything seems to go well during my configure:<br>
//----------------<br>
<br>
./configure --with-pgconfig=/usr/bin/pg_config \<br>
--with-xml2config=/usr/local/src/libxml2-2.7.6/xml2-config \<br>
--with-proj \<br>
--with-geosconfig=/usr/local/bin/geos-config \<br>
<br>
--with-pgsql<br>
//----------------<br>
The make results:<br>
//----------------<br>
PostGIS was built successfully. Ready to install.<br>
//----------------<br>
But make install isn't as neat:<br>
//----------------<br>
/bin/sh /usr/lib64/pgsql/pgxs/src/makefiles/../../config/install-sh -c<br>
shp2pgsql /usr/bin<br>
make[1]: Leaving directory `/usr/local/src/postgis-1.5.2/loader'<br>
//----------------<br>
And, my resulting attempts to create a PostGIS database do not succeed.<br>
Here's my commands:<br>
<br>
#login as postgres<br>
sudo su postgres<br>
#create database stuff<br>
createdb example_db<br>
createlang plpgsql example_db<br>
psql -d example_db -f /usr/share/pgsql/contrib/postgis-1.5/postgis.sql<br>
<br>
psql -d example_db -f<br>
/usr/share/pgsql/contrib/postgis-1.5/spatial_ref_sys.sql<br>
#logout of postgres user<br>
exit<br>
<br>
Anyone have advice on what to look for in a successful install?<br>
<br>
<br>
<br>
</div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br>