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

On 12/19/20 2:54 AM, Rambabu V wrote:

Hi Team,

i have installed postgresql 13 using packages/tried same using lower
versions as well, but replication not working, getting below error.

What OS and version?

Where did you get packages?

Do you have other versions of Postgres running on this machine?

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
2020-12-19 02:48:22.350 PST [3575] 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
2020-12-19 02:48:27.362 PST [3576] 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
2020-12-19 02:48:32.366 PST [3580] 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

even though i have exported LD_LIBRARY_PATH and created link also.

[root@localhost log]# which libpqwalreceiver.so
/usr/bin/libpqwalreceiver.so
[root@localhost log]# which libpq.so.5
/usr/bin/libpq.so.5

[postgres@localhost ~]$ export LD_LIBRARY_PATH=$PATH:/usr/pgsql-13/lib/
[postgres@localhost ~]$ echo $LD_LIBRARY_PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/postgres/.local/bin:/home/postgres/bin:/usr/pgsql-13/lib/

every version has the same issue with packages, please help me to
resolve this issue.

--
Adrian Klaver
adrian.klaver@aklaver.com

Rambabu V <ram.wissen@gmail.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

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, no other versions running in the server now.

[root@node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root@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@node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@node2 ~]#

On Sat, Dec 19, 2020 at 9:02 PM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

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@node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root@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@node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@node2 ~]#

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

On 12/19/20 4:53 PM, Rambabu V wrote:

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, no other versions running in the server now.

[root@node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root@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@node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@node2 ~]#

Where are you getting the packages?

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi Team,

below is the link im getting packages.

https://www.postgresql.org/download/linux/redhat/

On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <adrian.klaver@aklaver.com>
wrote:

On 12/19/20 5:05 PM, Rambabu V wrote:

Hi Team,

below is the link im getting packages.

https://www.postgresql.org/download/linux/redhat/
<https://www.postgresql.org/download/linux/redhat/&gt;

This was fixed here:

https://redmine.postgresql.org/issues/4509

You will need community account to see issue.

Relevant parts:

2019-07-24
"After some analysis we found that the issue was the addition of
`X509_get_signature_nid` function calls in PG11, and the fact that the
customer was still on openssl-libs 1.0.1e, which doesn't have that
function implemented, and not the latest 1.0.2k available.

For that reason the postgresql11-libs should have a dependency so
openssl-libs 1.0.2 or better is installed."

...

2019-08-30

"I updated PostgreSQL 10+ spec files:

https://git.postgresql.org/gitweb/?p=pgrpms.git;a=commit;h=86f8778e077d250e9b3c0e695d5cc297057c511a

These changes will appear in next minor updates.
"

Have you looked at this announcement?:

https://yum.postgresql.org/news/new-repo-rpms-released/

On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

On 12/19/20 4:53 PM, Rambabu V wrote:

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, no other versions running in the

server now.

[root@node2 ~]# openssl version
OpenSSL 1.0.1e-fips 11 Feb 2013
[root@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@node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)
[root@node2 ~]#

Where are you getting the packages?

--
Adrian Klaver
adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com

Hi,

On Sun, 2020-12-20 at 06:23 +0530, Rambabu V wrote:

[root@node2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.2 (Maipo)

IIRC RHEL 7 RPMs support RHEL 7.6+. Please update.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR