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.10with 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:
undefinedsymbol: 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