Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
От | Justin Pryzby |
---|---|
Тема | Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) |
Дата | |
Msg-id | 20171219213013.GA22497@telsasoft.com обсуждение исходный текст |
Ответ на | Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6) (Justin Pryzby <pryzby@telsasoft.com>) |
Список | pgsql-pkg-yum |
On Mon, Dec 18, 2017 at 08:56:35AM -0600, Justin Pryzby wrote: > On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote: > > On Fri, Dec 15, 2017 at 06:05:51AM +0300, Devrim Gündüz wrote: > > > > > > proj > > > > > > Please grab this from EPEL: > > > > > > https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/p/ > > > > For centos6, I think there's an issue with the version of proj in EPEL combined > > with postgis10_24: > > > > [pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head > ... > > psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:94: ERROR: could not load library "/usr/pgsql-10/lib/postgis-2.4.so":/usr/pgsql-10/lib/postgis-2.4.so: undefined symbol: pj_get_spheroid_defn > > I meant to also say: > I think that indicates a missing dependency version in the postgis package. I > know that in debian, this kind of thing is handled by dpkg-shlibdeps. I was doing another deployment (ansible) and again ran into same issue (I think): TASK: [legacy_appserver | create postgis environment] ************************* failed: [new.gta] => {"failed": true, "item": ""} msg: Database query failed: could not load library "/usr/pgsql-10/lib/postgis-2.4.so": /usr/pgsql-10/lib/postgis-2.4.so:undefined symbol: geod_init gdal-libs.x86_64 1.9.2-8.rhel6 @pgdg10 geos.x86_64 3.5.0-1.rhel6 @pgdg10 geos36.x86_64 3.6.2-2.rhel6 @pgdg10 geos36-devel.x86_64 3.6.2-2.rhel6 @pgdg10 libgeotiff.x86_64 1.4.0-1.rhel6 @pgdg96 postgis24_10.x86_64 2.4.2-3.rhel6 @pgdg10 proj.x86_64 4.8.0-2.rhel6 @pgdg10 libspatialite.x86_64 2.4.0-0.6.RC4.el6 @epel I see: https://trac.osgeo.org/postgis/ticket/3142 [pryzbyj@gta-mtx-telsa ~]$ yum list --showdu proj Loaded plugins: etckeeper, fastestmirror, security Loading mirror speeds from cached hostfile * base: centos.mirror.ndchost.com * epel: mirror.sjc02.svwh.net * extras: mirror.lax.hugeserver.com * ius: mirror.team-cymru.org * updates: mirrors.usc.edu Installed Packages proj.x86_64 4.8.0-2.rhel6 @pgdg10 Available Packages proj.i686 4.7.0-1.el6 epel proj.x86_64 4.7.0-1.el6 epel proj.x86_64 4.8.0-2.rhel6 pgdg10 proj.x86_64 4.8.0-2.rhel6 pgdg96 I was able to work around by doing: sudo yum downgrade postgis24_10{,-client,-utils}-2.4.2-1.rhel6 Was the postgis24_10 built against a proj from centos7 or not available in repo? -- Justin Pryzby System Administrator Telsasoft +1-952-707-8581
В списке pgsql-pkg-yum по дате отправления: