Re: [postgis-users] Error adding raster support
> -Original Message- > But I'm getting the following error: > > psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql:70: ERROR: > could not load library "/usr/lib/postgresql/9.1/lib/rtpostgis-2.0.so": > libgdal.so.1: cannot open shared object file: No such file or directory > Do you have gdal installed? This electronic message contains information generated by the USDA solely for the intended recipients. Any unauthorized interception of this message or the use or disclosure of the information it contains may violate the law and subject the violator to civil or criminal penalties. If you believe you have received this message in error, please notify the sender and delete the email immediately. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Luis, The problem is that the libgdal.so.1 file can't be found. Did you use a GDAL package or compile your own? If you're using a GDAL package through ubuntu or debian, the gdal libraries having their version number attached to the filename causing problems. You should search the list for the last few months as people have had issues with GDAL provided by debian (and derived distros). I forget what the resolution was but I know that one was found. -bborie On 06/06/2012 06:22 AM, Luis wrote: > Hello everyone, > > I have Postgres 9.1 and Postgis 2.0 on Ubuntu Server 10.04. I'd like to add > raster support to a spatial database, feeding the raster SQL file: > > $ psql -f /usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql -d > mydatabase > > But I'm getting the following error: > > psql:/usr/share/postgresql/9.1/contrib/postgis-2.0/rtpostgis.sql:70: ERROR: > could not load library "/usr/lib/postgresql/9.1/lib/rtpostgis-2.0.so": > libgdal.so.1: cannot open shared object file: No such file or directory > > I thought this was a permission issue, but it is not: > > $ ls -la /usr/lib/postgresql/9.1/lib/rtpostgis-2.0.so > -rwxr-xr-x 1 root root 1275398 2012-06-05 16:33 > /usr/lib/postgresql/9.1/lib/rtpostgis-2.0.so > > So what's going on here? Can it be solved somehow? > > Thank you very much. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > ___ > 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
Re: [postgis-users] Error adding raster support
Thank you all for the replies. Initially I tried to install GDAL from the repos, which for Ubuntu 10.04 is only available in version 1.6.0. But contrary to what the readme files says PostGis 2 doesn't go with this version of GDAL. So I download and compiled GDAL 1.9.1, hence I doubt it is an issue. Any other insights would be very welcome. Thank you. -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998070.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Luis, PostGIS 2.0 does support GDAL 1.6. I'm expecting that the GDAL 1.6 coming from the repos uses the naming convention libgdal16.so.1 instead of the default libgdal.so.1, which is known to cause problems. Were you compiling PostGIS 2.0 or using a package from a repo? -bborie On Thu, Jun 7, 2012 at 4:36 AM, Luis wrote: > Thank you all for the replies. > > Initially I tried to install GDAL from the repos, which for Ubuntu 10.04 is > only available in version 1.6.0. But contrary to what the readme files says > PostGis 2 doesn't go with this version of GDAL. So I download and compiled > GDAL 1.9.1, hence I doubt it is an issue. > > Any other insights would be very welcome. > > Thank you. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998070.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > ___ > 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
Re: [postgis-users] Error adding raster support
Hi Bborie, I compiled PostGIS 2 from the source. It is not available in the repos for Ubuntu 10.04. Thank you. -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998112.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Any further information on this issue would be very welcome. I still haven't succeed in adding raster support to PostGIS. Thank you. -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998424.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Hey Luis, Can you run ldd on rtpostgis-2.0.so? ldd rtpostgis-2.0.so -bborie On 06/20/2012 03:00 AM, Luis wrote: > Any further information on this issue would be very welcome. I still haven't > succeed in adding raster support to PostGIS. > > Thank you. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998424.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > ___ > 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
Re: [postgis-users] Error adding raster support
Hi Bborie, here it is: $ ldd /home/weastflows/temp/postgis-2.0.0/raster/rt_pg/rtpostgis-2.0.so linux-vdso.so.1 => (0x7fffb8c98000) libgdal.so.1 => /usr/local/lib/libgdal.so.1 (0x7fde9a573000) libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x7fde9a34e000) libc.so.6 => /lib/libc.so.6 (0x7fde99fca000) libgeos-3.3.4.so => /usr/local/lib/libgeos-3.3.4.so (0x7fde99c29000) libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0x7fdec000) libodbc.so.1 => not found libodbcinst.so.1 => not found libxerces-c.so.28 => not found libjasper.so.1 => not found libnetcdf.so.4 => not found libhdf5.so.6 => not found libmfhdfalt.so.0 => not found libdfalt.so.0 => not found libgif.so.4 => not found libjpeg.so.62 => not found libpng12.so.0 => /lib/libpng12.so.0 (0x7fde99771000) libpq.so.5 => /usr/lib/libpq.so.5 (0x7fde99544000) libz.so.1 => /lib/libz.so.1 (0x7fde9932c000) libpthread.so.0 => /lib/libpthread.so.0 (0x7fde9910f000) librt.so.1 => /lib/librt.so.1 (0x7fde98f07000) libdl.so.2 => /lib/libdl.so.2 (0x7fde98d02000) libcurl-gnutls.so.4 => /usr/lib/libcurl-gnutls.so.4 (0x7fde98abf000) libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x7fde987ab000) libm.so.6 => /lib/libm.so.6 (0x7fde98527000) libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x7fde9831) /lib64/ld-linux-x86-64.so.2 (0x7fde9b549000) libssl.so.0.9.8 => /lib/libssl.so.0.9.8 (0x7fde980bd000) libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0x7fde97d2c000) libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x7fde97a68000) libcom_err.so.2 => /lib/libcom_err.so.2 (0x7fde97863000) libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 (0x7fde9762f000) libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0x7fde973e3000) libidn.so.11 => /usr/lib/libidn.so.11 (0x7fde971af000) liblber-2.4.so.2 => /usr/lib/liblber-2.4.so.2 (0x7fde96fa1000) libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0x7fde96cff000) libgcrypt.so.11 => /lib/libgcrypt.so.11 (0x7fde96a86000) libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x7fde9686) libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 (0x7fde96657000) libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x7fde96454000) libresolv.so.2 => /lib/libresolv.so.2 (0x7fde9623b000) libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x7fde9602) libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0x7fde95e0f000) libgpg-error.so.0 => /lib/libgpg-error.so.0 (0x7fde95c0b000) Thanks for answering. -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998559.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Hey Luis, What happens when you run "gdalinfo" or "gdal_translate" without any parameters? I'm expecting an error message indicating that GDAL can't find some library. I'm guessing that the GDAL library can't find the libraries it was compiled against. If you run "ldd" on libgdal.so.1 and still get the "not found" messages, you'll want to check your GDAL build. -bborie On Mon, Jun 25, 2012 at 12:38 AM, Luis wrote: > Hi Bborie, here it is: > > $ ldd /home/weastflows/temp/postgis-2.0.0/raster/rt_pg/rtpostgis-2.0.so > linux-vdso.so.1 => (0x7fffb8c98000) > libgdal.so.1 => /usr/local/lib/libgdal.so.1 (0x7fde9a573000) > libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0x7fde9a34e000) > libc.so.6 => /lib/libc.so.6 (0x7fde99fca000) > libgeos-3.3.4.so => /usr/local/lib/libgeos-3.3.4.so > (0x7fde99c29000) > libsqlite3.so.0 => /usr/lib/libsqlite3.so.0 (0x7fdec000) > libodbc.so.1 => not found > libodbcinst.so.1 => not found > libxerces-c.so.28 => not found > libjasper.so.1 => not found > libnetcdf.so.4 => not found > libhdf5.so.6 => not found > libmfhdfalt.so.0 => not found > libdfalt.so.0 => not found > libgif.so.4 => not found > libjpeg.so.62 => not found > libpng12.so.0 => /lib/libpng12.so.0 (0x7fde99771000) > libpq.so.5 => /usr/lib/libpq.so.5 (0x7fde99544000) > libz.so.1 => /lib/libz.so.1 (0x7fde9932c000) > libpthread.so.0 => /lib/libpthread.so.0 (0x7fde9910f000) > librt.so.1 => /lib/librt.so.1 (0x7fde98f07000) > libdl.so.2 => /lib/libdl.so.2 (0x7fde98d02000) > libcurl-gnutls.so.4 => /usr/lib/libcurl-gnutls.so.4 > (0x7fde98abf000) > libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x7fde987ab000) > libm.so.6 => /lib/libm.so.6 (0x7fde98527000) > libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x7fde9831) > /lib64/ld-linux-x86-64.so.2 (0x7fde9b549000) > libssl.so.0.9.8 => /lib/libssl.so.0.9.8 (0x7fde980bd000) > libcrypto.so.0.9.8 => /lib/libcrypto.so.0.9.8 (0x7fde97d2c000) > libkrb5.so.3 => /usr/lib/libkrb5.so.3 (0x7fde97a68000) > libcom_err.so.2 => /lib/libcom_err.so.2 (0x7fde97863000) > libgssapi_krb5.so.2 => /usr/lib/libgssapi_krb5.so.2 > (0x7fde9762f000) > libldap_r-2.4.so.2 => /usr/lib/libldap_r-2.4.so.2 (0x7fde973e3000) > libidn.so.11 => /usr/lib/libidn.so.11 (0x7fde971af000) > liblber-2.4.so.2 => /usr/lib/liblber-2.4.so.2 (0x7fde96fa1000) > libgnutls.so.26 => /usr/lib/libgnutls.so.26 (0x7fde96cff000) > libgcrypt.so.11 => /lib/libgcrypt.so.11 (0x7fde96a86000) > libk5crypto.so.3 => /usr/lib/libk5crypto.so.3 (0x7fde9686) > libkrb5support.so.0 => /usr/lib/libkrb5support.so.0 > (0x7fde96657000) > libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x7fde96454000) > libresolv.so.2 => /lib/libresolv.so.2 (0x7fde9623b000) > libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x7fde9602) > libtasn1.so.3 => /usr/lib/libtasn1.so.3 (0x7fde95e0f000) > libgpg-error.so.0 => /lib/libgpg-error.so.0 (0x7fde95c0b000) > > Thanks for answering. > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998559.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > ___ > 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
Re: [postgis-users] Error adding raster support
Hi Bborie, sorry for the belated response I haven't been at the office the past few weeks. As you suspected something is wrong with gdal: $ gdalinfo gdalinfo: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory $ gdal_translate gdal_translate: error while loading shared libraries: libodbc.so.1: cannot open shared object file: No such file or directory I'll have to sort this out before I get back to PostGIS. Any suggestions on how to do it are welcome. Thank you for the help, Luís -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998832.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Error adding raster support
Dear all, I managed to solve this issue following your advice. GDAL was properly installed but a few libraries on which it depends where missing. After installing them it was possible to add the raster support without trouble. Once again thank you very much for your help, Luís -- View this message in context: http://postgis.17.n6.nabble.com/Error-adding-raster-support-tp4998034p4998848.html Sent from the PostGIS - User mailing list archive at Nabble.com. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users