Re: [postgis-users] PostGIS 2 RPM
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 Lakej...@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* MichiganWxSystemhttp://www.michiganwxsystem.com AllisonHousehttp://www.allisonhouse.com GRLevelXStuffhttp://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* MichiganWxSystemhttp://www.michiganwxsystem.com AllisonHousehttp://www.allisonhouse.com GRLevelXStuffhttp://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@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* MichiganWxSystemhttp://www.michiganwxsystem.com AllisonHousehttp://www.allisonhouse.com GRLevelXStuffhttp://www.grlevelxstuff.com On 10/19/2012 14:23, Bborie Park wrote: gdal-config --dep-libs ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Heh. ldd looks good. I suspect the only possibility is to set up a similar environment using CentOS 5.8 and see what happens. -bborie On 10/18/2012 08:19 PM, Jeff Lake wrote: [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4 linux-vdso.so.1 = (0x7fff68bfd000) libssl.so.6 = /lib64/libssl.so.6 (0x2acdf6791000) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2acdf69de000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2acdf6d2f000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2acdf6f5d000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2acdf7196000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2acdf73e) libc.so.6 = /lib64/libc.so.6 (0x2acdf75fb000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2acdf7953000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2acdf7be8000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2acdf7dea000) libdl.so.2 = /lib64/libdl.so.2 (0x2acdf801) libz.so.1 = /lib64/libz.so.1 (0x2acdf8214000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2acdf8428000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2acdf8631000) libresolv.so.2 = /lib64/libresolv.so.2 (0x2acdf8833000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2acdf8a48000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2acdf8c57000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2acdf8e7) libsepol.so.1 = /lib64/libsepol.so.1 (0x2acdf9089000) [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so linux-vdso.so.1 = (0x7fff319fd000) libssl.so.6 = /lib64/libssl.so.6 (0x2aff2071) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2aff2095d000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2aff20cae000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2aff20edc000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2aff21115000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2aff2135f000) libc.so.6 = /lib64/libc.so.6 (0x2aff2157a000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2aff218d2000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2aff21b67000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2aff21d69000) libdl.so.2 = /lib64/libdl.so.2 (0x2aff21f8f000) libz.so.1 = /lib64/libz.so.1 (0x2aff22193000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2aff223a7000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2aff225b) libresolv.so.2 = /lib64/libresolv.so.2 (0x2aff227b2000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2aff229c7000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2aff22bd6000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2aff22def000) libsepol.so.1 = /lib64/libsepol.so.1 (0x2aff23008000) CentOS 5.8 64bit *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 22:58, Bborie Park wrote: Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq RPM packager is speaking: IIRC this error does not mean that it is not finding the PostgreSQL libs,
Re: [postgis-users] PostGIS 2 RPM
There is something messed up I see this in configure 'checking for PQserverVersion in -lpq... yes' but yet make complains it can't find -lpq '/usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status' huh *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/19/2012 12:16, Bborie Park wrote: Heh. ldd looks good. I suspect the only possibility is to set up a similar environment using CentOS 5.8 and see what happens. -bborie On 10/18/2012 08:19 PM, Jeff Lake wrote: [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4 linux-vdso.so.1 = (0x7fff68bfd000) libssl.so.6 = /lib64/libssl.so.6 (0x2acdf6791000) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2acdf69de000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2acdf6d2f000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2acdf6f5d000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2acdf7196000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2acdf73e) libc.so.6 = /lib64/libc.so.6 (0x2acdf75fb000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2acdf7953000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2acdf7be8000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2acdf7dea000) libdl.so.2 = /lib64/libdl.so.2 (0x2acdf801) libz.so.1 = /lib64/libz.so.1 (0x2acdf8214000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2acdf8428000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2acdf8631000) libresolv.so.2 = /lib64/libresolv.so.2 (0x2acdf8833000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2acdf8a48000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2acdf8c57000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2acdf8e7) libsepol.so.1 = /lib64/libsepol.so.1 (0x2acdf9089000) [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so linux-vdso.so.1 = (0x7fff319fd000) libssl.so.6 = /lib64/libssl.so.6 (0x2aff2071) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2aff2095d000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2aff20cae000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2aff20edc000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2aff21115000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2aff2135f000) libc.so.6 = /lib64/libc.so.6 (0x2aff2157a000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2aff218d2000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2aff21b67000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2aff21d69000) libdl.so.2 = /lib64/libdl.so.2 (0x2aff21f8f000) libz.so.1 = /lib64/libz.so.1 (0x2aff22193000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2aff223a7000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2aff225b) libresolv.so.2 = /lib64/libresolv.so.2 (0x2aff227b2000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2aff229c7000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2aff22bd6000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2aff22def000) libsepol.so.1 = /lib64/libsepol.so.1 (0x2aff23008000) CentOS 5.8 64bit *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 22:58, Bborie Park wrote: Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq
Re: [postgis-users] PostGIS 2 RPM
Yeah. I noticed that as well. I took a look at my config.log and it looked fine. You may want to check your config.log as well. -bborie On 10/19/2012 09:34 AM, Jeff Lake wrote: There is something messed up I see this in configure 'checking for PQserverVersion in -lpq... yes' but yet make complains it can't find -lpq '/usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status' huh *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/19/2012 12:16, Bborie Park wrote: Heh. ldd looks good. I suspect the only possibility is to set up a similar environment using CentOS 5.8 and see what happens. -bborie On 10/18/2012 08:19 PM, Jeff Lake wrote: [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4 linux-vdso.so.1 = (0x7fff68bfd000) libssl.so.6 = /lib64/libssl.so.6 (0x2acdf6791000) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2acdf69de000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2acdf6d2f000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2acdf6f5d000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2acdf7196000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2acdf73e) libc.so.6 = /lib64/libc.so.6 (0x2acdf75fb000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2acdf7953000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2acdf7be8000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2acdf7dea000) libdl.so.2 = /lib64/libdl.so.2 (0x2acdf801) libz.so.1 = /lib64/libz.so.1 (0x2acdf8214000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2acdf8428000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2acdf8631000) libresolv.so.2 = /lib64/libresolv.so.2 (0x2acdf8833000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2acdf8a48000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2acdf8c57000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2acdf8e7) libsepol.so.1 = /lib64/libsepol.so.1 (0x2acdf9089000) [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so linux-vdso.so.1 = (0x7fff319fd000) libssl.so.6 = /lib64/libssl.so.6 (0x2aff2071) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2aff2095d000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2aff20cae000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2aff20edc000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2aff21115000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2aff2135f000) libc.so.6 = /lib64/libc.so.6 (0x2aff2157a000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2aff218d2000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2aff21b67000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2aff21d69000) libdl.so.2 = /lib64/libdl.so.2 (0x2aff21f8f000) libz.so.1 = /lib64/libz.so.1 (0x2aff22193000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2aff223a7000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2aff225b) libresolv.so.2 = /lib64/libresolv.so.2 (0x2aff227b2000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2aff229c7000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2aff22bd6000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2aff22def000) libsepol.so.1 = /lib64/libsepol.so.1 (0x2aff23008000) CentOS 5.8 64bit *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 22:58, Bborie Park wrote: Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include
Re: [postgis-users] PostGIS 2 RPM
Oh yeah. Did you trying running make like the following? LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make Another approach is to run just make in the base directory. Once it fails, go into raster/loader and run the above make. That way we can focus on just that step. -bborie On 10/19/2012 09:34 AM, Jeff Lake wrote: There is something messed up I see this in configure 'checking for PQserverVersion in -lpq... yes' but yet make complains it can't find -lpq '/usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status' huh *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/19/2012 12:16, Bborie Park wrote: Heh. ldd looks good. I suspect the only possibility is to set up a similar environment using CentOS 5.8 and see what happens. -bborie On 10/18/2012 08:19 PM, Jeff Lake wrote: [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4 linux-vdso.so.1 = (0x7fff68bfd000) libssl.so.6 = /lib64/libssl.so.6 (0x2acdf6791000) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2acdf69de000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2acdf6d2f000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2acdf6f5d000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2acdf7196000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2acdf73e) libc.so.6 = /lib64/libc.so.6 (0x2acdf75fb000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2acdf7953000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2acdf7be8000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2acdf7dea000) libdl.so.2 = /lib64/libdl.so.2 (0x2acdf801) libz.so.1 = /lib64/libz.so.1 (0x2acdf8214000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2acdf8428000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2acdf8631000) libresolv.so.2 = /lib64/libresolv.so.2 (0x2acdf8833000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2acdf8a48000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2acdf8c57000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2acdf8e7) libsepol.so.1 = /lib64/libsepol.so.1 (0x2acdf9089000) [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so linux-vdso.so.1 = (0x7fff319fd000) libssl.so.6 = /lib64/libssl.so.6 (0x2aff2071) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2aff2095d000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2aff20cae000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2aff20edc000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2aff21115000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2aff2135f000) libc.so.6 = /lib64/libc.so.6 (0x2aff2157a000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2aff218d2000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2aff21b67000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2aff21d69000) libdl.so.2 = /lib64/libdl.so.2 (0x2aff21f8f000) libz.so.1 = /lib64/libz.so.1 (0x2aff22193000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2aff223a7000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2aff225b) libresolv.so.2 = /lib64/libresolv.so.2 (0x2aff227b2000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2aff229c7000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2aff22bd6000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2aff22def000) libsepol.so.1 = /lib64/libsepol.so.1 (0x2aff23008000) CentOS 5.8 64bit *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 22:58, Bborie Park wrote: Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql
Re: [postgis-users] PostGIS 2 RPM
LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make same results can't find -lpq running make in raster/loader /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make: *** [raster2pgsql] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/19/2012 12:43, Bborie Park wrote: LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
A ticket was made for this issue. http://trac.osgeo.org/postgis/ticket/2057 From digging at my dev box, I'm wondering if you can give me the output from gdal-config... gdal-config --dep-libs Looking at libtool's debug output when linking raster2pgsql, the -lpq is coming from GDAL's dependency... -bborie On 10/19/2012 10:02 AM, Jeff Lake wrote: LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make same results can't find -lpq running make in raster/loader /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make: *** [raster2pgsql] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/19/2012 12:43, Bborie Park wrote: LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
[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 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
the Makefile from r10484 gets rid of the original error can I build postGIS without-mysql ?? didn't even know mysql was an option cause now I get ... /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com 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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
It's not. That would once again be from GDAL's dependency on MySQL. -bborie On 10/19/2012 02:26 PM, Jeff Lake wrote: the Makefile from r10484 gets rid of the original error can I build postGIS without-mysql ?? didn't even know mysql was an option cause now I get ... /usr/bin/ld: cannot find -lmysqlclient collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com 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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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 http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com 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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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 j...@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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
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 j...@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@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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Your initial email message indicated an error in the raster/loader make step but that step has no errors in the make.log (bottom of the file). -bborie On 10/18/2012 02:14 PM, Jeff Lake wrote: Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center
Re: [postgis-users] PostGIS 2 RPM
the log doesnt show it, but #make make.log Can't fetch local revision (neither .svn nor .git found) Not updating existing rev file at 9979 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[1]: *** [rtloader] Error 2 make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:22, Bborie Park wrote: Your initial email message indicated an error in the raster/loader make step but that step has no errors in the make.log (bottom of the file). -bborie On 10/18/2012 02:14 PM, Jeff Lake wrote: Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[2]: Leaving directory `/postgis-2.0.1/raster/loader' make[1]: *** [rtloader] Error 2 make[1]: Leaving directory `/postgis-2.0.1/raster' make: *** [all] Error 1 -- Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
I'm going to need some background regarding your PostgreSQL installation. 1. Are there multiple instances of PostgreSQL installed? 2. What version are you running? 3. What is the output of pg_config? Specifically, LIBDIR. Since the error states that ld can't find libpq, something is up with the environment. That probably explains why you had issues with --without-raster and errors happened when applying postgis.sql. -bborie On 10/18/2012 02:37 PM, Jeff Lake wrote: the log doesnt show it, but #make make.log Can't fetch local revision (neither .svn nor .git found) Not updating existing rev file at 9979 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[1]: *** [rtloader] Error 2 make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:22, Bborie Park wrote: Your initial email message indicated an error in the raster/loader make step but that step has no errors in the make.log (bottom of the file). -bborie On 10/18/2012 02:14 PM, Jeff Lake wrote: Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info - C compiler: gcc -g -O2 C++ compiler: g++ -g -O2 SQL preprocessor: /usr/bin/cpp -traditional-cpp -P -- Dependencies -- GEOS config: /geos-3.3.5/tools/geos-config GEOS version: 3.3.5 GDAL config: /usr/local/bin/gdal-config GDAL version: 1.9.1 PostgreSQL config:/usr/pgsql-9.1/bin/pg_config PostgreSQL version: PostgreSQL 9.1.6 PROJ4 version:48 Libxml2 config: /usr/bin/xml2-config Libxml2 version: 2.6.26 JSON-C support: no PostGIS debug level: 0 Perl: /usr/bin/perl --- Extensions --- PostGIS Raster: enabled PostGIS Topology: enabled Documentation Generation xsltproc: /usr/bin/xsltproc xsl style sheets: dblatex: convert: /usr/bin/convert mathml2.dtd: http://www.w3.org/Math/DTD/mathml2/mathml2.dtd Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm
Re: [postgis-users] PostGIS 2 RPM
No other installs, had 8.4, but completely wiped it before 9.1.6 was installed [root@ldm postgis-2.0.1]# /usr/pgsql-9.1/bin/pg_config BINDIR = /usr/pgsql-9.1/bin DOCDIR = /usr/share/doc/pgsql HTMLDIR = /usr/share/doc/pgsql INCLUDEDIR = /usr/pgsql-9.1/include PKGINCLUDEDIR = /usr/pgsql-9.1/include INCLUDEDIR-SERVER = /usr/pgsql-9.1/include/server LIBDIR = /usr/pgsql-9.1/lib PKGLIBDIR = /usr/pgsql-9.1/lib LOCALEDIR = /usr/pgsql-9.1/share/locale MANDIR = /usr/pgsql-9.1/share/man SHAREDIR = /usr/pgsql-9.1/share SYSCONFDIR = /etc/sysconfig/pgsql PGXS = /usr/pgsql-9.1/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.1' '--includedir=/usr/pgsql-9.1/include' '--mandir=/usr/pgsql-9.1/share/man' '--datadir=/usr/pgsql-9.1/share' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/share/doc' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et' CC = gcc CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL = -fpic LDFLAGS = -L/usr/lib64 LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -ltermcap -lcrypt -ldl -lm VERSION = PostgreSQL 9.1.6 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:43, Bborie Park wrote: I'm going to need some background regarding your PostgreSQL installation. 1. Are there multiple instances of PostgreSQL installed? 2. What version are you running? 3. What is the output of pg_config? Specifically, LIBDIR. Since the error states that ld can't find libpq, something is up with the environment. That probably explains why you had issues with --without-raster and errors happened when applying postgis.sql. -bborie On 10/18/2012 02:37 PM, Jeff Lake wrote: the log doesnt show it, but #make make.log Can't fetch local revision (neither .svn nor .git found) Not updating existing rev file at 9979 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[1]: *** [rtloader] Error 2 make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:22, Bborie Park wrote: Your initial email message indicated an error in the raster/loader make step but that step has no errors in the make.log (bottom of the file). -bborie On 10/18/2012 02:14 PM, Jeff Lake wrote: Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep getting raster error configure params ./configure --with-raster --with-pgconfig=/usr/pgsql-9.1/bin/pg_config --with-geosconfig=/geos-3.3.5/tools/geos-config PostGIS is now configured for x86_64-unknown-linux-gnu -- Compiler Info
Re: [postgis-users] PostGIS 2 RPM
See if you can run make setting LD_LIBRARY_PATH. Something like the following. LD_LIBRARY_PATH=/usr/pgsql-9.1/lib make -bborie On 10/18/2012 03:39 PM, Jeff Lake wrote: No other installs, had 8.4, but completely wiped it before 9.1.6 was installed [root@ldm postgis-2.0.1]# /usr/pgsql-9.1/bin/pg_config BINDIR = /usr/pgsql-9.1/bin DOCDIR = /usr/share/doc/pgsql HTMLDIR = /usr/share/doc/pgsql INCLUDEDIR = /usr/pgsql-9.1/include PKGINCLUDEDIR = /usr/pgsql-9.1/include INCLUDEDIR-SERVER = /usr/pgsql-9.1/include/server LIBDIR = /usr/pgsql-9.1/lib PKGLIBDIR = /usr/pgsql-9.1/lib LOCALEDIR = /usr/pgsql-9.1/share/locale MANDIR = /usr/pgsql-9.1/share/man SHAREDIR = /usr/pgsql-9.1/share SYSCONFDIR = /etc/sysconfig/pgsql PGXS = /usr/pgsql-9.1/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.1' '--includedir=/usr/pgsql-9.1/include' '--mandir=/usr/pgsql-9.1/share/man' '--datadir=/usr/pgsql-9.1/share' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-krb5' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--with-ossp-uuid' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/share/doc' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et' CC = gcc CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include CFLAGS = -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wformat-security -fno-strict-aliasing -fwrapv CFLAGS_SL = -fpic LDFLAGS = -L/usr/lib64 LDFLAGS_EX = LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -ltermcap -lcrypt -ldl -lm VERSION = PostgreSQL 9.1.6 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:43, Bborie Park wrote: I'm going to need some background regarding your PostgreSQL installation. 1. Are there multiple instances of PostgreSQL installed? 2. What version are you running? 3. What is the output of pg_config? Specifically, LIBDIR. Since the error states that ld can't find libpq, something is up with the environment. That probably explains why you had issues with --without-raster and errors happened when applying postgis.sql. -bborie On 10/18/2012 02:37 PM, Jeff Lake wrote: the log doesnt show it, but #make make.log Can't fetch local revision (neither .svn nor .git found) Not updating existing rev file at 9979 /usr/bin/ld: cannot find -lpq collect2: ld returned 1 exit status make[2]: *** [raster2pgsql] Error 1 make[1]: *** [rtloader] Error 2 make: *** [all] Error 1 *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 17:22, Bborie Park wrote: Your initial email message indicated an error in the raster/loader make step but that step has no errors in the make.log (bottom of the file). -bborie On 10/18/2012 02:14 PM, Jeff Lake wrote: Yes I did .. #vim /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf #dir /etc/ld.so.conf.d atlas-x86_64.conf kernelcap-2.6.18-308.16.1.el5.conf mysql-x86_64.conf xulrunner-32.conf kernelcap-2.6.18-308.13.1.el5.conf mysqlclient15-x86_64.conf postgresql-pgdg-libs.conf xulrunner-64.conf #vim postgresql-pgdg-libs.conf /usr/pgsql-9.1/lib here is log files of configure and make http://www2.michiganwxsystem.net/configure.log http://www2.michiganwxsystem.net/make.log *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 11:33, Bborie Park wrote: Did you run ldconfig after adding the lib path to ld.so.conf? -bborie On 10/18/2012 08:20 AM, Jeff Lake wrote: Well that sounded promising but no joy, even tried --without-raster and got error's galore when I tried to apply postgis.sql to my tables *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 10:24, Bborie Park wrote: It looks like the linker can't find libpq. You'll want to add the following to /etc/ld.so.conf. /usr/pgsql-9.1/lib -bborie On Thu, Oct 18, 2012 at 6:09 AM, Jeff Lake j...@michiganwxsystem.com wrote: Is there any reasoning why EL5 does not have a postGIS2_91 RPM ?? this is on CentOS 5.8 64bit I have tried numerous times to install from source and keep
Re: [postgis-users] PostGIS 2 RPM
Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq RPM packager is speaking: IIRC this error does not mean that it is not finding the PostgreSQL libs, but one of the dependencies are not built with PostgreSQL support (which I don't remember now). Please upgrade to RHEL6 -- it will be less painful as compared to trying to build PostGIS 2.0 with raster support. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq RPM packager is speaking: IIRC this error does not mean that it is not finding the PostgreSQL libs, but one of the dependencies are not built with PostgreSQL support (which I don't remember now). Please upgrade to RHEL6 -- it will be less painful as compared to trying to build PostGIS 2.0 with raster support. Regards, ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq RPM packager is speaking: IIRC this error does not mean that it is not finding the PostgreSQL libs, but one of the dependencies are not built with PostgreSQL support (which I don't remember now). Please upgrade to RHEL6 -- it will be less painful as compared to trying to build PostGIS 2.0 with raster support. Regards, ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PostGIS 2 RPM
[root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so.5.4 linux-vdso.so.1 = (0x7fff68bfd000) libssl.so.6 = /lib64/libssl.so.6 (0x2acdf6791000) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2acdf69de000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2acdf6d2f000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2acdf6f5d000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2acdf7196000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2acdf73e) libc.so.6 = /lib64/libc.so.6 (0x2acdf75fb000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2acdf7953000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2acdf7be8000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2acdf7dea000) libdl.so.2 = /lib64/libdl.so.2 (0x2acdf801) libz.so.1 = /lib64/libz.so.1 (0x2acdf8214000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2acdf8428000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2acdf8631000) libresolv.so.2 = /lib64/libresolv.so.2 (0x2acdf8833000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2acdf8a48000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2acdf8c57000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2acdf8e7) libsepol.so.1 = /lib64/libsepol.so.1 (0x2acdf9089000) [root@ldm /]# ldd /usr/pgsql-9.1/lib/libpq.so linux-vdso.so.1 = (0x7fff319fd000) libssl.so.6 = /lib64/libssl.so.6 (0x2aff2071) libcrypto.so.6 = /lib64/libcrypto.so.6 (0x2aff2095d000) libgssapi_krb5.so.2 = /usr/lib64/libgssapi_krb5.so.2 (0x2aff20cae000) libcrypt.so.1 = /lib64/libcrypt.so.1 (0x2aff20edc000) libldap_r-2.3.so.0 = /usr/lib64/libldap_r-2.3.so.0 (0x2aff21115000) libpthread.so.0 = /lib64/libpthread.so.0 (0x2aff2135f000) libc.so.6 = /lib64/libc.so.6 (0x2aff2157a000) libkrb5.so.3 = /usr/lib64/libkrb5.so.3 (0x2aff218d2000) libcom_err.so.2 = /lib64/libcom_err.so.2 (0x2aff21b67000) libk5crypto.so.3 = /usr/lib64/libk5crypto.so.3 (0x2aff21d69000) libdl.so.2 = /lib64/libdl.so.2 (0x2aff21f8f000) libz.so.1 = /lib64/libz.so.1 (0x2aff22193000) libkrb5support.so.0 = /usr/lib64/libkrb5support.so.0 (0x2aff223a7000) libkeyutils.so.1 = /lib64/libkeyutils.so.1 (0x2aff225b) libresolv.so.2 = /lib64/libresolv.so.2 (0x2aff227b2000) liblber-2.3.so.0 = /usr/lib64/liblber-2.3.so.0 (0x2aff229c7000) libsasl2.so.2 = /usr/lib64/libsasl2.so.2 (0x2aff22bd6000) /lib64/ld-linux-x86-64.so.2 (0x003f2d80) libselinux.so.1 = /lib64/libselinux.so.1 (0x2aff22def000) libsepol.so.1 = /lib64/libsepol.so.1 (0x2aff23008000) CentOS 5.8 64bit *Jeff Lake* MichiganWxSystem http://www.michiganwxsystem.com AllisonHouse http://www.allisonhouse.com GRLevelXStuff http://www.grlevelxstuff.com On 10/18/2012 22:58, Bborie Park wrote: Before you give up, can you run ldd on libpq? Also, what OS and version? -bborie On Thu, Oct 18, 2012 at 6:51 PM, Jeff Lake j...@michiganwxsystem.com wrote: well I guess I'm stuck at 1.5.5 this server is relied on to much to be taken offline for OS upgrade Jeff Lake MichiganWxSystem AllisonHouse GRLevelXStuff On 10/18/2012 19:26, Devrim GÜNDÜZ wrote: Hi, On Thu, 2012-10-18 at 09:09 -0400, Jeff Lake wrote: Entering directory `/postgis-2.0.1/raster/loader' /bin/sh ../../libtool --mode=link gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o ../rt_core/librtcore.a ../rt_core/librtcore.a ../../liblwgeom/liblwgeom.la -L/usr/local/lib -lgdal -L/usr/local/lib -lgeos_c -lc -lm -o raster2pgsql libtool: link: gcc -g -O2 -fPIC -DPIC -Wall -Wmissing-prototypes -I../rt_core -I../../liblwgeom -I/usr/local/include -I/usr/local/include raster2pgsql.o -o .libs/raster2pgsql ../rt_core/librtcore.a ../../liblwgeom/.libs/liblwgeom.so -L/usr/local/lib /usr/local/lib/libproj.so /usr/local/lib/libgdal.so -L/usr/lib64 -L/usr/kerberos/lib64 -L/usr/lib64/mysql -lsqlite3 /usr/lib64/libexpat.so -lgif -ljpeg -lpng -lpq -lcurl -lgssapi_krb5 -lkrb5 -lk5crypto -lcom_err -lidn -lz -lmysqlclient -lpthread -lrt -lssl -lcrypto -ldl /usr/local/lib/libgeos_c.so /usr/local/lib/libgeos.so -lc -lm -Wl,-rpath -Wl,/usr/local/lib -Wl,-rpath -Wl,/usr/lib64 /usr/bin/ld: cannot find -lpq RPM packager is speaking: IIRC this error does not mean that it is not finding the PostgreSQL libs, but one of the dependencies are not built with PostgreSQL support (which I don't remember now). Please upgrade to RHEL6 -- it will be less painful as compared to trying to build PostGIS 2.0 with raster support. Regards,