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

Hi Team,

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
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.
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:
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
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:
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
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.


On Sun, Dec 20, 2020 at 6:33 AM Adrian Klaver <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
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/>

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

Attachment