<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">persistence pays off !!!<br>
<br>
I threw the directions from the postgresql page that deals with
upgrading 8.4 to 9.1 away<br>
that is where 90% of my problems came from.<br>
Trying to update a re-constructed 8.4 database to postGIS2 was
causing all kinds of trouble<br>
<br>
started from scratch..<br>
mysql 5.0.95<br>
fresh install pgsql 9.1.6<br>
GDAL 1.9.2<br>
GEOS 3.3.5<br>
python 2.4<br>
php 5.4.8<br>
postGIS-2.01<br>
on CentOS 5.8 64bit<br>
<br>
<br>
I kept restoring my 8.4 db in 9.1.6<br>
and the errors where to many to keep track of trying to upgrade
the db to postGIS-2<br>
so I started from zero, no tables..<br>
recreated the tables on at a time, applied the postgis sql files
as needed<br>
then simply re-imported my shape files, and other data I had in
there to begin with<br>
<br>
so .. one server down ... 2 more to go<br>
Thanks for the help<br>
<br>
-Jeff<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<div class="moz-signature"><b>Jeff Lake</b><br>
<a href="http://www.michiganwxsystem.com">MichiganWxSystem</a><br>
<a href="http://www.allisonhouse.com">AllisonHouse</a><br>
<a href="http://www.grlevelxstuff.com">GRLevelXStuff</a></div>
On 10/19/2012 22:06, Jeff Lake wrote:<br>
</div>
<blockquote cite="mid:50820732.9090804@michiganwxsystem.com"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<div class="moz-cite-prefix">I tried<br>
but because I have upgraded libmysql and mySQL after I first
built GDAL<br>
GDAL fails I imagine if I go back a few versions on libmysql and
mySQL to<br>
the required libmysql.15 GDAL will install no problem<br>
<br>
<br>
<div class="moz-signature"><b>Jeff Lake</b><br>
<a moz-do-not-send="true"
href="http://www.michiganwxsystem.com">MichiganWxSystem</a><br>
<a moz-do-not-send="true" href="http://www.allisonhouse.com">AllisonHouse</a><br>
<a moz-do-not-send="true" href="http://www.grlevelxstuff.com">GRLevelXStuff</a></div>
On 10/19/2012 22:00, Bborie Park wrote:<br>
</div>
<blockquote
cite="mid:CALT_QHDuUW+5X_Tu7ngQ=j=GrqiY2NjHuu+on+ay2m1d60ke8w@mail.gmail.com"
type="cite">
<pre wrap="">Can you rebuild your GDAL? I'm going to have to poke a few machines
to see how they all respond to gdal-config --dep-libs
-bborie
On Fri, Oct 19, 2012 at 6:38 PM, Jeff Lake <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:jeff@michiganwxsystem.com"><jeff@michiganwxsystem.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I appreciate the assistance.
but seeings how GDAL only supports libmysql15, and the latest is libmysql18
I can't build GDAL against it, and hence postGIS 2.0 fails
I'm really not in the mood to go backwards with mySQL and/or libmysql
just to obtain the little I will
(already been though this with GDAL .. I can see supporting libmysql15 + not
JUST 15
Jeff Lake
MichiganWxSystem
AllisonHouse
GRLevelXStuff
On 10/19/2012 14:57, Bborie Park wrote:
So, GDAL was built using the prior PostgreSQL (8.4 series). I wonder
what happens if you call "gdalinfo" without any arguments. Usually,
there will be error messages about missing libraries if what GDAL was
built against is missing. If you're not getting any error messages,
just use the changed Makefile.in from r10484
-bborie
On 10/19/2012 11:54 AM, Jeff Lake wrote:
I was just going to ask if I should rebuild GDAL
GDAL was built before 9.1.6 was ...
*Jeff Lake*
MichiganWxSystem <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/19/2012 14:48, Bborie Park wrote:
Was GDAL built against that 9.1.6 RPM? I've committed some changes for
2.0 branch in r10484 so feel free to use that. That'll ame sure the
linking goes correctly.
I was expecting that your output of gdal-config --dep-libs would include
a -L to the your libpq since your libpq is in /usr/pgsql-9.1/lib/
-bborie
On 10/19/2012 11:44 AM, Jeff Lake wrote:
GDAL was built from source (1.9.1)
PostgreSQL (-contrib|-server|-devel|-libs) were built from RPM's (9.1.6)
*Jeff Lake*
MichiganWxSystem <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/19/2012 14:36, Bborie Park wrote:
Are the versions of GDAL and PostgreSQL from packages or ones you
built?
Thanks for providing all the feedback... I'm trying to see what the
best
way to fix this is.
-bborie
On 10/19/2012 11:31 AM, Jeff Lake wrote:
[root@ldm /]# gdal-config --dep-libs
-L/usr/lib64 -lgeos_c -lsqlite3 -lexpat -lgif -ljpeg -lpng
-L/usr/lib64
-lpq -lz -lpthread -lm -lrt -ldl -L/usr/kerberos/lib64 -lcurl -ldl
-lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lssl -lcrypto -lz
-L/usr/lib64/mysql -lmysqlclient -lpthread -lm -lrt -lssl -lcrypto
-ldl
*Jeff Lake*
MichiganWxSystem <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/19/2012 14:23, Bborie Park wrote:
gdal-config --dep-libs
_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
_______________________________________________
postgis-users mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
<br>
</blockquote>
<br>
</body>
</html>