[postgis-users] PostGIS 2 RPM

Bborie Park bkpark at ucdavis.edu
Thu Oct 18 16:02:31 PDT 2012


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 at 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
>>>>>>>> <jeff at 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 at postgis.refractions.net
>>>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> postgis-users mailing list
>>>>>>> postgis-users at postgis.refractions.net
>>>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> postgis-users mailing list
>>>>> postgis-users at postgis.refractions.net
>>>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
> 
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu



More information about the postgis-users mailing list