Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)
Дата
Msg-id 20171216190101.GP18184@telsasoft.com
обсуждение исходный текст
Ответ на Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)  (Devrim Gündüz <devrim@gunduz.org>)
Ответы Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)  (Justin Pryzby <pryzby@telsasoft.com>)
Список pgsql-pkg-yum
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 ~]$ yum list --showdu proj
...
Installed Packages
proj.x86_64                                                                           4.7.0-1.el6
                                                     @epel
 
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
                                                     pgdg96
 

[pryzbyj@db ~]$ psql 3rivers -f /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql 2>&1 |head
BEGIN
SET
DO
CREATE FUNCTION
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
 
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:99: ERROR:  current transaction is aborted, commands ignored
untilend of transaction block
 
psql:/usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql:107: ERROR:  current transaction is aborted, commands ignored
untilend of transaction block
 

[pryzbyj@db ~]$ nm -D /usr/lib64/libproj.so.0.6.6 |grep pj_get_spheroid_defn || echo NOT FOUND
NOT FOUND

proj 4.8 from PGDG96 works ok:

[pryzbyj@db ~]$ psql 3rivers -qf /usr/pgsql-10/share/contrib/postgis-2.4/postgis.sql && echo OK
OK

[pryzbyj@db ~]$ sudo yum list --showduplicates postgis24_10{,-client,-utils} libgeotiff gdal-libs libspatialite proj
Loaded plugins: etckeeper, fastestmirror, security
Loading mirror speeds from cached hostfile
 * base: mirror.scalabledns.com
 * epel: mirror.chpc.utah.edu
 * extras: repos.forethought.net
 * ius: ord.mirror.rackspace.com
 * updates: repos.forethought.net
Installed Packages
gdal-libs.x86_64                                                                           1.9.2-8.rhel6
                                                    @pgdg10
 
libgeotiff.x86_64                                                                          1.4.0-1.rhel6
                                                    @pgdg96
 
libspatialite.x86_64                                                                       2.4.0-0.6.RC4.el6
                                                    @epel  
 
postgis24_10.x86_64                                                                        2.4.2-1.rhel6
                                                    @pgdg10
 
postgis24_10-client.x86_64                                                                 2.4.2-1.rhel6
                                                    @pgdg10
 
postgis24_10-utils.x86_64                                                                  2.4.2-1.rhel6
                                                    @pgdg10
 
proj.x86_64                                                                                4.8.0-2.rhel6
                                                    @pgdg96
 
Available Packages
gdal-libs.x86_64                                                                           1.9.2-8.rhel6
                                                    pgdg10 
 
gdal-libs.x86_64                                                                           1.9.2-8.rhel6
                                                    pgdg96 
 
libgeotiff.i686                                                                            1.2.5-6.el6
                                                    epel   
 
libgeotiff.x86_64                                                                          1.2.5-6.el6
                                                    epel   
 
libgeotiff.x86_64                                                                          1.4.0-1.rhel6
                                                    pgdg96 
 
libspatialite.i686                                                                         2.4.0-0.6.RC4.el6
                                                    epel   
 
libspatialite.x86_64                                                                       2.4.0-0.6.RC4.el6
                                                    epel   
 
postgis24_10.x86_64                                                                        2.4.1-1.rhel6
                                                    pgdg10 
 
postgis24_10.x86_64                                                                        2.4.2-1.rhel6
                                                    pgdg10 
 
postgis24_10-client.x86_64                                                                 2.4.1-1.rhel6
                                                    pgdg10 
 
postgis24_10-client.x86_64                                                                 2.4.2-1.rhel6
                                                    pgdg10 
 
postgis24_10-utils.x86_64                                                                  2.4.1-1.rhel6
                                                    pgdg10 
 
postgis24_10-utils.x86_64                                                                  2.4.2-1.rhel6
                                                    pgdg10 
 
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
                                                    pgdg96 
 

Thanks for your support in this and in building RPMs.

Justin


В списке pgsql-pkg-yum по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: Skytools for 10 — RPM missing
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: libgeotiff (Re: PG10 postgis24 + gdal on RHEL6)