The following bug has been logged on the website:
Bug reference: 15576
Logged by: Chen huajun
Email address: chjischj@163.com
PostgreSQL version: 11.1
Operating system: CentOS Linux release 7.1.1503 (Core)
Description:
When use yum installed PostgreSQL 11.1 , missing X509_get_signature_nid
symbol causes the standby to fail to start stream replication, the logs in
the standby are as follows
2019-01-05 00:40:24.468 CST [46191] FATAL: could not load library
"/usr/pgsql-11/lib/libpqwalreceiver.so": /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
This is the same problem as described in the email below.
https://www.postgresql.org/message-id/20180627155748.GD3554%40telsasoft.com
My environment is as follows:
[root@node3 pha4pgsql]# rpm -qa|grep postgresql11
postgresql11-devel-11.1-1PGDG.rhel7.x86_64
postgresql11-libs-11.1-1PGDG.rhel7.x86_64
postgresql11-contrib-11.1-1PGDG.rhel7.x86_64
postgresql11-11.1-1PGDG.rhel7.x86_64
postgresql11-server-11.1-1PGDG.rhel7.x86_64
[root@node3 pha4pgsql]# rpm -qf /lib64/libcrypto.so.10
openssl-libs-1.0.1e-42.el7.x86_64