BUG #15877: Cannot CREATE EXTENSION for postgis 2.4 because ofmissing gdal23-libs ldconfig path

Поиск
Список
Период
Сортировка
От Karl O. Pinc
Тема BUG #15877: Cannot CREATE EXTENSION for postgis 2.4 because ofmissing gdal23-libs ldconfig path
Дата
Msg-id 20190627114402.5553addf@slate.karlpinc.com
обсуждение исходный текст
Ответы Re: BUG #15877: Cannot CREATE EXTENSION for postgis 2.4 because ofmissing gdal23-libs ldconfig path  (Devrim Gündüz <devrim@gunduz.org>)
Список pgsql-pkg-yum
Hello,

I've sent an email to the PG bugs mailing list but the #postgis
IRC channel suggested that this might be a better place to report
the bug.

https://www.postgresql.org/message-id/15877-023bd263ded090b8%40postgresql.org

For your convenience I am copying the bug report below:
-------------------------------<snip>-------------------

The following bug has been logged on the website:

Bug reference:      15877
Logged by:          Karl Pinc
Email address:      kop(at)karlpinc(dot)com
PostgreSQL version: 10.9
Operating system:   Red Hat Enterprise Linux Server release 7.6 (Maipo
Description:        

Other installed packages:
postgis24_10.x86_64                    2.4.7-3.rhel7                    
@pgdg10
gdal-libs.x86_64                      1.11.4-12.rhel7                   
@pgdg10
gdal23-libs.x86_64                    2.3.2-7.rhel7                     
@pgdg10

I tried restoring a database with postgis installed in it and could not:

$ pg_restore -U babase_admin -1 -d karl_test < /tmp/babase_test.custom 
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2; 3079 320225 EXTENSION
postgis 
pg_restore: [archiver (db)] could not execute query: ERROR:  could not load
library "/usr/pgsql-10/lib/rtpostgis-2.4.so": libgdal.so.20: cannot open
shared object file: No such file or directory
    Command was: CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA
postgis;

The fix was to add the file: /etc/ld.so.conf.d/gdal23-pgdg-libs.conf
The content is:
  /usr/gdal23/lib/

Then, I ran: ldconfig

I suspect that someone needs to add /usr/gdal23/lib to whatever rpm package
configures ldconfig
for postgis.  There is a /etc/ld.so.conf.d/geos37-pgdg-libs.conf file from
the geos37 package,
so maybe the gdal23-libs package needs to do the same thing?

Thanks for your attention.

Regards,

Karl <kop@meme.com>
Free Software:  "You don't pay back, you pay forward."
                 -- Robert A. Heinlein



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

Предыдущее
От: Greg Clough
Дата:
Сообщение: Missing old version of RepMgr?
Следующее
От: Devrim Gündüz
Дата:
Сообщение: Re: Unable to install pgsql under RHEL8