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 -------------
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
_______________________________________________
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