[postgis-users] PostGIS 2 RPM

[Jeff Lake]

persistence pays off !!!

I threw the directions from the postgresql page that deals with 
upgrading 8.4 to 9.1 away
that is where 90% of my problems came from.
Trying to update a re-constructed 8.4 database to postGIS2 was causing 
all kinds of trouble

started from scratch..
mysql 5.0.95
fresh install pgsql 9.1.6
GDAL 1.9.2
GEOS 3.3.5
python 2.4
php 5.4.8
postGIS-2.01
on CentOS 5.8 64bit


I kept restoring my 8.4 db in 9.1.6
and the errors where to many to keep track of trying to upgrade the db 
to postGIS-2
so I started from zero, no tables..
recreated the tables on at a time, applied the postgis sql files as needed
then simply re-imported my shape files, and other data I had in there to 
begin with

so .. one server down ... 2 more to go
Thanks for the help

-Jeff








*Jeff Lake*
MichiganWxSystem <http://www.michiganwxsystem.com>
AllisonHouse <http://www.allisonhouse.com>
GRLevelXStuff <http://www.grlevelxstuff.com>
On 10/19/2012 22:06, Jeff Lake wrote:
> I tried
> but because I have upgraded libmysql and mySQL after I first built GDAL
> GDAL fails I imagine if I go back a few versions on libmysql and mySQL to
> the required libmysql.15 GDAL will install no problem
>
>
> *Jeff Lake*
> MichiganWxSystem <http://www.michiganwxsystem.com>
> AllisonHouse <http://www.allisonhouse.com>
> GRLevelXStuff <http://www.grlevelxstuff.com>
> On 10/19/2012 22:00, Bborie Park wrote:
>> 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<jeff at michiganwxsystem.com>  wrote:
>>> 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<http://www.michiganwxsystem.com>
>>> AllisonHouse<http://www.allisonhouse.com>
>>> GRLevelXStuff<http://www.grlevelxstuff.com>
>>> 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<http://www.michiganwxsystem.com>
>>> AllisonHouse<http://www.allisonhouse.com>
>>> GRLevelXStuff<http://www.grlevelxstuff.com>
>>> 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 at 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<http://www.michiganwxsystem.com>
>>> AllisonHouse<http://www.allisonhouse.com>
>>> GRLevelXStuff<http://www.grlevelxstuff.com>
>>> On 10/19/2012 14:23, Bborie Park wrote:
>>>
>>> gdal-config --dep-libs
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121022/3a2a1f28/attachment.html>