[postgis-users] PostGIS 2 RPM
Bborie Park
bkpark at ucdavis.edu
Thu Oct 18 14:43:57 PDT 2012
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
>
--
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark at ucdavis.edu
More information about the postgis-users
mailing list