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 > -- Bborie Park Programmer Center for Vectorborne Diseases UC Davis 530-752-8380 bkp...@ucdavis.edu _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
