Re: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication

Hi,

You need to update openssl.

Regards, Devrim

On 17 April 2019 08:12:53 GMT+03:00, soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com> wrote:
>
>Hi ,
>When use yum installed PostgreSQL 11.2 , missing X509_get_signature_nid
>symbol causes the standby to fail to start stream replication, the logs
>in
>the standby are as follows .
>
>Is this a bug with PostgreSQL 11.2 for streaming replication ? Is
>there any way out or any different release is there ? Please suggest .
>
>Postgres version :
>PostgreSQL 11.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
>20150623 (Red Hat 4.8.5-36), 64-bit
>
>Os version :
>Red Hat Enterprise Linux Server release 7.2 (Maipo)
>
>2019-04-17 10:15:48.752 IST [15386] LOG: database system is ready to
>accept read only connections
>2019-04-17 10:15:48.755 IST [15393] 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
>2019-04-17 10:15:48.758 IST [15394] 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
>2019-04-17 10:15:53.764 IST [15398] 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
>2019-04-17 10:15:58.772 IST [15403] 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
>2019-04-17 10:16:03.776 IST [15408] 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
>
>
>Same issue reported in below mail chain as well .
>
>https://www.postgresql-archive.org/BUG-15576-Missing-X509-get-signature-nid-symbol-causes-the-standby-to-fail-to-start-stream-replicatin-td6065301.html#a6065751
>
>Thanks,
>Soumitra

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.