From: soumitra bhandary <soumitra.bhandary@hotmail.com>
To: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Subject: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication
Date: Wed, 17 Apr 2019 05:12:53 +0000
Message-ID: <MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <MA1PR01MB3548A25F7C5470286B81EF03E0250@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM>
References: <MA1PR01MB3548A25F7C5470286B81EF03E0250@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM>
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-standb...
Thanks,
Soumitra
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: soumitra.bhandary@hotmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: Fw: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication
In-Reply-To: <MA1PR01MB354840F4AA7B39EEB5B5AD7EE0250@MA1PR01MB3548.INDPRD01.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox