[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