Re: FATAL: could not load library "/usr/pgsql-13/lib/libpqwalreceiver.so" during replication

Hi Team,

below are the os versions details. standalone machine running without any
issues, coming to replication not working, even i tried from postgresql 10
onwards as well.

[root(at)node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root(at)node2 ~]# uname -a
Linux node2 3.10.0-327.el7.x86_64 #1 SMP Thu Oct 29 17:29:29 EDT 2015
x86_64 x86_64 x86_64 GNU/Linux
[root(at)node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root(at)node2 ~]#

On Sat, Dec 19, 2020 at 10:18 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Rambabu V <ram(dot)wissen(at)gmail(dot)com> writes:
> > i have installed postgresql 13 using packages/tried same using lower
> > versions as well, but replication not working, getting below error.
>
> > 2020-12-19 02:48:22.346 PST [3574] FATAL: could not load library
> > "/usr/pgsql-13/lib/libpqwalreceiver.so": /usr/pgsql-13/lib/libpq.so.5:
> > symbol X509_get_signature_nid, version libcrypto.so.10 not defined in
> file
> > libcrypto.so.10 with link time reference
>
> Apparently this copy of libpq was built against a newer version of
> OpenSSL than what you have installed locally. The man page for
> X509_get_signature_nid says it was added in OpenSSL 1.0.2, in case that
> helps. You need to find or build a version of Postgres that's intended
> for your specific platform version. Alternatively, maybe you would be
> better off moving to a newer platform version, or at least installing
> a newer OpenSSL version. Anything older than 1.0.1 is considered
> outright insecure these days.
>
> regards, tom lane
>