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
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)
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
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
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,
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
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
[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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 =
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]#
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
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
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
[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
31 matches
Mail list logo