[postgis-users] PostGIS 2 RPM
Jeff Lake
jeff at michiganwxsystem.com
Thu Oct 18 15:39:03 PDT 2012
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
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121018/c011de86/attachment.html>
More information about the postgis-users
mailing list