Date: Wed, 27 Jun 2018 10:57:48 -0500
From: Justin Pryzby <pryzby@telsasoft.com>
To: Devrim =?iso-8859-1?B?R/xuZPx6?= <devrim@gunduz.org>
Cc: pgsql-pkg-yum@postgresql.org
Subject: shared library version issues (yum/pgdg)
Message-ID: <20180627155748.GD3554@telsasoft.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.23 (2014-03-12)
Precedence: bulk

It looks like there's still an issue with symbol references, at least on
centos6/x86_64/pg11b1.

Perhaps postgres was compiled in one environment with a later version of
libraries - but I don't know how RPMs intend to handle that.

import _pg # pygresql
ImportError: /usr/pgsql-11/lib/libpq.so.5: symbol X509_get_signature_nid, version libcrypto.so.10 not defined in file libcrypto.so.10 with link time reference

[pryzbyj@template0 ~]$ rpm -qf /usr/lib64/libcrypto.so.10
openssl-libs-1.0.1e-60.el7_3.1.x86_64

Fixed by installing openssl-libs-1.0.2k-12.el7.x86_64.rpm

I reported several similar problems 6 months ago:

On Sat, Dec 16, 2017 at 01:01:01PM -0600, Justin Pryzby wrote:
> For centos6, I think there's an issue with the version of proj in EPEL combined
> with postgis10_24:
...
> 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

On Tue, Jan 23, 2018 at 11:34:50AM -0600, Justin Pryzby wrote:
> Following yum update on centos6:
> InternalError: 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

On Fri, Feb 02, 2018 at 07:56:26PM -0600, Justin Pryzby wrote:
> pg_restore: [archiver (db)] Error from TOC entry 2732; 1255 16405 FUNCTION box2d_in(cstring) postgres
> pg_restore: [archiver (db)] could not execute query: ERROR:  could not load library "/usr/pgsql-9.6/lib/postgis-2.1.so": /usr/pgsql-9.6/lib/postgis-2.1.so: undefined symbol: pj_get_spheroid_defn

Thanks in advance.

Justin