BUG #14989: Postgis 2.4.2 for PostgreSQL 10 fails to install
От | PG Bug reporting form |
---|---|
Тема | BUG #14989: Postgis 2.4.2 for PostgreSQL 10 fails to install |
Дата | |
Msg-id | 20171221150656.826.71281@wrigleys.postgresql.org обсуждение исходный текст |
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 14989 Logged by: James Roos Email address: roosj@leidos.com PostgreSQL version: 10.1 Operating system: CentOS 6.9 Description: After installing PostgreSQL 10.1 on a fresh CentOS 6.9 system I attempted to install the PostGIS 2.4 extension. The basic procedures followed are: # yum install -y https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm # yum install -y epel-release # yum install postgresql10-server postgresql10 postgresql10-contrib PostgreSQL 10.1 successfully installs # yum install postgis24_10 Loaded plugins: fastestmirror, remove-with-leaves Setting up Install Process Loading mirror speeds from cached hostfile * base: mirror.rackspace.com * epel: mirror.compevo.com * extras: repos.forethought.net * updates: mirror.lax.hugeserver.com Resolving Dependencies --> Running transaction check ---> Package postgis24_10.x86_64 0:2.4.2-3.rhel6 will be installed --> Processing Dependency: geos36 >= 3.6.2 for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: gdal-libs >= 1.9.0 for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: proj49 for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: json-c for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: hdf5 for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: libproj.so.12()(64bit) for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: libproj.so.0()(64bit) for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: libjson-c.so.2()(64bit) for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: libgeos_c.so.1()(64bit) for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Processing Dependency: libgdal.so.1()(64bit) for package: postgis24_10-2.4.2-3.rhel6.x86_64 --> Running transaction check ---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed --> Processing Dependency: libpng12.so.0(PNG12_0)(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libjpeg.so.62(LIBJPEG_6.2)(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libxerces-c-3.0.so()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libtiff.so.3()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libspatialite.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libpoppler.so.5()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libpng12.so.0()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libodbcinst.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libodbc.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libnetcdf.so.6()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libjpeg.so.62()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libjasper.so.1()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libgta.so.0()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libgif.so.4()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libgeotiff.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libfreexl.so.1()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libdapserver.so.7()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libdapclient.so.3()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libdap.so.11()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libcfitsio.so.0()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libarmadillo.so.4()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 --> Processing Dependency: libCharLS.so.1()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 ---> Package geos36.x86_64 0:3.6.2-2.rhel6 will be installed ---> Package geos36-devel.x86_64 0:3.6.2-2.rhel6 will be installed ---> Package hdf5.x86_64 0:1.8.5.patch1-10.el6 will be installed --> Processing Dependency: libgfortran.so.3(GFORTRAN_1.0)(64bit) for package: hdf5-1.8.5.patch1-10.el6.x86_64 --> Processing Dependency: libgfortran.so.3()(64bit) for package: hdf5-1.8.5.patch1-10.el6.x86_64 ---> Package json-c.x86_64 0:0.11-13.el6 will be installed ---> Package proj.x86_64 0:4.8.0-2.rhel6 will be installed ---> Package proj49.x86_64 0:4.9.3-3.rhel6 will be installed --> Running transaction check ---> Package CharLS.x86_64 0:1.0-5.el6 will be installed ---> Package armadillo.x86_64 0:4.550.2-1.el6 will be installed --> Processing Dependency: libarpack.so.2()(64bit) for package: armadillo-4.550.2-1.el6.x86_64 --> Processing Dependency: libblas.so.3()(64bit) for package: armadillo-4.550.2-1.el6.x86_64 --> Processing Dependency: libcblas.so.3()(64bit) for package: armadillo-4.550.2-1.el6.x86_64 --> Processing Dependency: libclapack.so.3()(64bit) for package: armadillo-4.550.2-1.el6.x86_64 --> Processing Dependency: liblapack.so.3()(64bit) for package: armadillo-4.550.2-1.el6.x86_64 ---> Package cfitsio.x86_64 0:3.240-3.el6 will be installed ---> Package freexl.x86_64 0:1.0.4-1.el6 will be installed ---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed --> Processing Dependency: libgeotiff.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 ---> Package giflib.x86_64 0:4.1.6-3.1.el6 will be installed --> Processing Dependency: libX11.so.6()(64bit) for package: giflib-4.1.6-3.1.el6.x86_64 --> Processing Dependency: libSM.so.6()(64bit) for package: giflib-4.1.6-3.1.el6.x86_64 --> Processing Dependency: libICE.so.6()(64bit) for package: giflib-4.1.6-3.1.el6.x86_64 ---> Package jasper-libs.x86_64 0:1.900.1-21.el6_9 will be installed ---> Package libdap.x86_64 0:3.11.0-1.el6 will be installed ---> Package libgfortran.x86_64 0:4.4.7-18.el6 will be installed ---> Package libgta.x86_64 0:1.0.2-2.el6 will be installed ---> Package libjpeg-turbo.x86_64 0:1.2.1-3.el6_5 will be installed ---> Package libpng.x86_64 2:1.2.49-2.el6_7 will be installed ---> Package libspatialite.x86_64 0:2.4.0-0.6.RC4.el6 will be installed ---> Package libtiff.x86_64 0:3.9.4-21.el6_8 will be installed ---> Package netcdf.x86_64 0:4.1.1-3.el6.5 will be installed ---> Package poppler.x86_64 0:0.12.4-12.el6_9 will be installed --> Processing Dependency: poppler-data >= 0.4.0 for package: poppler-0.12.4-12.el6_9.x86_64 --> Processing Dependency: libopenjpeg.so.2()(64bit) for package: poppler-0.12.4-12.el6_9.x86_64 --> Processing Dependency: liblcms.so.1()(64bit) for package: poppler-0.12.4-12.el6_9.x86_64 --> Processing Dependency: libfreetype.so.6()(64bit) for package: poppler-0.12.4-12.el6_9.x86_64 --> Processing Dependency: libfontconfig.so.1()(64bit) for package: poppler-0.12.4-12.el6_9.x86_64 ---> Package unixODBC.x86_64 0:2.2.14-14.el6 will be installed --> Processing Dependency: libltdl.so.7()(64bit) for package: unixODBC-2.2.14-14.el6.x86_64 ---> Package xerces-c.x86_64 0:3.0.1-20.el6 will be installed --> Running transaction check ---> Package arpack.x86_64 0:3.1.3-1.el6 will be installed ---> Package atlas.x86_64 0:3.8.4-2.el6 will be installed ---> Package blas.x86_64 0:3.2.1-5.el6 will be installed ---> Package fontconfig.x86_64 0:2.8.0-5.el6 will be installed ---> Package freetype.x86_64 0:2.3.11-17.el6 will be installed ---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed --> Processing Dependency: libgeotiff.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 ---> Package lcms-libs.x86_64 0:1.19-1.el6 will be installed ---> Package libICE.x86_64 0:1.0.6-1.el6 will be installed ---> Package libSM.x86_64 0:1.2.1-2.el6 will be installed ---> Package libX11.x86_64 0:1.6.4-3.el6 will be installed --> Processing Dependency: libX11-common = 1.6.4-3.el6 for package: libX11-1.6.4-3.el6.x86_64 --> Processing Dependency: libxcb.so.1()(64bit) for package: libX11-1.6.4-3.el6.x86_64 ---> Package libtool-ltdl.x86_64 0:2.2.6-15.5.el6 will be installed ---> Package openjpeg-libs.x86_64 0:1.3-16.el6_8 will be installed ---> Package poppler-data.noarch 0:0.4.0-1.el6 will be installed --> Running transaction check ---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed --> Processing Dependency: libgeotiff.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 ---> Package libX11-common.noarch 0:1.6.4-3.el6 will be installed ---> Package libxcb.x86_64 0:1.12-4.el6 will be installed --> Processing Dependency: libXau.so.6()(64bit) for package: libxcb-1.12-4.el6.x86_64 --> Running transaction check ---> Package gdal-libs.x86_64 0:1.9.2-8.rhel6 will be installed --> Processing Dependency: libgeotiff.so.2()(64bit) for package: gdal-libs-1.9.2-8.rhel6.x86_64 ---> Package libXau.x86_64 0:1.0.6-4.el6 will be installed --> Finished Dependency Resolution Error: Package: gdal-libs-1.9.2-8.rhel6.x86_64 (pgdg10) Requires: libgeotiff.so.2()(64bit) You could try using --skip-broken to work around the problem You could try running: rpm -Va --nofiles --nodigest As the above message indicates GDAL 1.9.2 is being used. However, on the PostGIS Users Wiki (https://trac.osgeo.org/postgis/wiki/UsersWikiPostgreSQLPostGIS), PostGIS 2.4 requires GDAL 1.10 or greater. I was able to find the missing libgeotiff library in the libgeotiff package available in the PostgreSQL 9.6 yum repository. After installing the package, the postgis24_10 package successfully installed. However, when I tried to add the PostGIS extension in a new database, I got the message: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: geod_init I suspect this is related to the wrong version of GDAL being identified in the PostGIS dependencies.
В списке pgsql-bugs по дате отправления:
Предыдущее
От: Tom LaneДата:
Сообщение: Re: Order of columns in GROUP BY is significant to the planner.
Следующее
От: PG Bug reporting formДата:
Сообщение: BUG #14990: hashint4() <> hashint8() for small negative values,causing hash joins to fail