<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <div class="moz-cite-prefix">No other installs, had 8.4, but
      completely wiped it before 9.1.6 was installed<br>
      <br>
      [root@ldm postgis-2.0.1]# /usr/pgsql-9.1/bin/pg_config<br>
      BINDIR = /usr/pgsql-9.1/bin<br>
      DOCDIR = /usr/share/doc/pgsql<br>
      HTMLDIR = /usr/share/doc/pgsql<br>
      INCLUDEDIR = /usr/pgsql-9.1/include<br>
      PKGINCLUDEDIR = /usr/pgsql-9.1/include<br>
      INCLUDEDIR-SERVER = /usr/pgsql-9.1/include/server<br>
      LIBDIR = /usr/pgsql-9.1/lib<br>
      PKGLIBDIR = /usr/pgsql-9.1/lib<br>
      LOCALEDIR = /usr/pgsql-9.1/share/locale<br>
      MANDIR = /usr/pgsql-9.1/share/man<br>
      SHAREDIR = /usr/pgsql-9.1/share<br>
      SYSCONFDIR = /etc/sysconfig/pgsql<br>
      PGXS = /usr/pgsql-9.1/lib/pgxs/src/makefiles/pgxs.mk<br>
      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'<br>
      CC = gcc<br>
      CPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2
      -I/usr/include<br>
      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<br>
      CFLAGS_SL = -fpic<br>
      LDFLAGS = -L/usr/lib64<br>
      LDFLAGS_EX =<br>
      LDFLAGS_SL =<br>
      LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5
      -lz -lreadline -ltermcap -lcrypt -ldl -lm<br>
      VERSION = PostgreSQL 9.1.6<br>
      <br>
      <br>
      <br>
      <br>
      <div class="moz-signature"><b>Jeff Lake</b><br>
        <a href="http://www.michiganwxsystem.com">MichiganWxSystem</a><br>
        <a href="http://www.allisonhouse.com">AllisonHouse</a><br>
        <a href="http://www.grlevelxstuff.com">GRLevelXStuff</a></div>
      On 10/18/2012 17:43, Bborie Park wrote:<br>
    </div>
    <blockquote cite="mid:5080781D.6040301@ucdavis.edu" type="cite">
      <pre wrap="">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:
</pre>
      <blockquote type="cite">
        <pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/18/2012 17:22, Bborie Park wrote:
</pre>
        <blockquote type="cite">
          <pre wrap="">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:
</pre>
          <blockquote type="cite">
            <pre wrap="">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

<a class="moz-txt-link-freetext" href="http://www2.michiganwxsystem.net/configure.log">http://www2.michiganwxsystem.net/configure.log</a>
<a class="moz-txt-link-freetext" href="http://www2.michiganwxsystem.net/make.log">http://www2.michiganwxsystem.net/make.log</a>








*Jeff Lake*
MichiganWxSystem <a class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/18/2012 11:33, Bborie Park wrote:
</pre>
            <blockquote type="cite">
              <pre wrap="">Did you run "ldconfig" after adding the lib path to ld.so.conf?

-bborie

On 10/18/2012 08:20 AM, Jeff Lake wrote:
</pre>
              <blockquote type="cite">
                <pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="http://www.michiganwxsystem.com"><http://www.michiganwxsystem.com></a>
AllisonHouse <a class="moz-txt-link-rfc2396E" href="http://www.allisonhouse.com"><http://www.allisonhouse.com></a>
GRLevelXStuff <a class="moz-txt-link-rfc2396E" href="http://www.grlevelxstuff.com"><http://www.grlevelxstuff.com></a>
On 10/18/2012 10:24, Bborie Park wrote:
</pre>
                <blockquote type="cite">
                  <pre wrap="">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
<a class="moz-txt-link-rfc2396E" href="mailto:jeff@michiganwxsystem.com"><jeff@michiganwxsystem.com></a>
wrote:
</pre>
                  <blockquote type="cite">
                    <pre wrap="">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:
<a class="moz-txt-link-freetext" href="http://www.w3.org/Math/DTD/mathml2/mathml2.dtd">http://www.w3.org/Math/DTD/mathml2/mathml2.dtd</a>


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
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>

</pre>
                  </blockquote>
                </blockquote>
                <pre wrap="">

_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>

</pre>
              </blockquote>
            </blockquote>
            <pre wrap="">


_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>

</pre>
          </blockquote>
        </blockquote>
        <pre wrap="">



_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>

</pre>
      </blockquote>
      <pre wrap="">
</pre>
    </blockquote>
    <br>
  </body>
</html>