Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGng0-0000iP-Al for pgsql-admin@arkaria.postgresql.org; Wed, 17 Apr 2019 16:44:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hGnfz-0004Iw-0f for pgsql-admin@arkaria.postgresql.org; Wed, 17 Apr 2019 16:44:47 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGnfy-0004IF-Nc for pgsql-admin@lists.postgresql.org; Wed, 17 Apr 2019 16:44:46 +0000 Received: from mx2.mailbox.org ([80.241.60.215]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hGnfv-0001S8-QL for pgsql-admin@lists.postgresql.org; Wed, 17 Apr 2019 16:44:46 +0000 Received: from smtp2.mailbox.org (smtp2.mailbox.org [80.241.60.241]) (using TLSv1.2 with cipher ECDHE-RSA-CHACHA20-POLY1305 (256/256 bits)) (No client certificate requested) by mx2.mailbox.org (Postfix) with ESMTPS id DB2BBA1138; Wed, 17 Apr 2019 18:44:41 +0200 (CEST) X-Virus-Scanned: amavisd-new at heinlein-support.de Received: from smtp2.mailbox.org ([80.241.60.241]) by spamfilter01.heinlein-hosting.de (spamfilter01.heinlein-hosting.de [80.241.56.115]) (amavisd-new, port 10030) with ESMTP id HCuA7wub13XV; Wed, 17 Apr 2019 18:44:36 +0200 (CEST) Message-ID: <7748ff129ea2966e1943ba41f0a6a1f1702edb05.camel@cybertec.at> Subject: Re: PostgreSQL 11.2 , missing X509_get_signature_nid symbol causes the standby to fail to start stream replication From: Laurenz Albe To: soumitra bhandary , "pgsql-admin@lists.postgresql.org" Date: Wed, 17 Apr 2019 18:44:31 +0200 In-Reply-To: References: Organization: Cybertec Content-Type: text/plain; charset="UTF-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk soumitra bhandary wrote: > 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 That means that you have a bad version of libcrypto.so installed, which is part of the openssl-libs RPM. You could rpm -e --nodeps openssl-libs openssl and then yum install openssl openssl-libs to remove and reinstall the package. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com