Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ts3M8-00ED97-UD for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 11 Mar 2025 17:25:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ts3M7-003L1q-1f for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 11 Mar 2025 17:25:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ts3M6-003L0D-RM for pgsql-pkg-yum@lists.postgresql.org; Tue, 11 Mar 2025 17:25:26 +0000 Received: from mail1.bareos.com ([2a01:4f8:c17:7081::1]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ts3M3-002H6f-04 for pgsql-pkg-yum@lists.postgresql.org; Tue, 11 Mar 2025 17:25:26 +0000 Received: from mail.bareos.com (mail.bareos.com [188.68.34.205]) by mail1.bareos.com (Postfix) with ESMTPS id A4BCE5F784 for ; Tue, 11 Mar 2025 18:25:21 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by mail.bareos.com (Postfix) with ESMTP id 86F6E47C for ; Tue, 11 Mar 2025 18:25:21 +0100 (CET) X-Virus-Scanned: amavisd-new at bareos.com Received: from mail.bareos.com ([127.0.0.1]) by localhost (mail.bareos.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id G2QwZ2HrntMJ for ; Tue, 11 Mar 2025 18:25:18 +0100 (CET) Received: from [192.168.214.27] (pd9569228.dip0.t-ipconnect.de [217.86.146.40]) by mail.bareos.com (Postfix) with ESMTPSA id D0FE641A for ; Tue, 11 Mar 2025 18:25:18 +0100 (CET) Message-ID: Date: Tue, 11 Mar 2025 18:25:18 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird From: Andreas Rogge Subject: Re: BUG #18833: libpq.so doesn't contain declared symbol in rpm --provides To: pgsql-pkg-yum@lists.postgresql.org References: <202503101708.hmyugfg4rjpn@alvherre.pgsql> <425a672c6ca591a0ccee2a5d373764b6b561966f.camel@gunduz.org> <2082217.Jadu78ljVU@x-wing> Content-Language: de-DE, en-GB Autocrypt: addr=andreas.rogge@bareos.com; keydata= xsFNBGHSvG4BEACfWZrqZzpKqH6E8x6jk8QJDhyE2gH33P+8p9yTYkdDXSY1RUVQC8bH499V a9OIt5kGu2vlQqTSq0uXPj3CUDrj8Vl1cECj+YwORlPpF+Vpkw33rnRMLkwF8ksSGL/e49bp D2UwmpZoPw0Rw9X4ohJ74kyb15Gcs/u9ACDWbWHTWfgy24cIZDQRIeUnS+VInYlZUltkZvGN 50QoZJcB2oe/b7oSYSq1W1+QDc/7nFBpTztrydWXcQFQGBZnobojYYagh0M+B9mHc9wibb++ DCkKIAh3JeJU5K/RHtVCZ9lZ2ikcBJzZVtGFpVannoJRn3Z502qNSlkGgnRrPNlvMxsbb5vZ 1ta/gp1g2tD1IcwRVzoZUEoc/Lp0Rbq8CU2nYVBwMJX0t7R81pIzt7SyHuIHdPl/JIJxrWlm oi/6CorJLHCv0QSa6Q56W1Sg+k0jqnfg/r0Am9IWKoSFGYVGK9V6BiPsJB6eqlEkZoP10Ow5 FR2iOWawwZ8KgEoJWheb4HQQQ1IZYGYTJ435iRJoAe8PAl1NVYVM20zqes9PiKb3WtsDPqp4 kqKCde45ML7bSvXFq8VoDOSdW3Om4TV9Fu+0E4n1DnXk/2sVcWC5gL6ECYuIoTA7JlCakKt9 3Kvhdt/YfKIgyo5yEK64d8KOJ2s4qMQ+l4yah6lBwQxqwjN/AQARAQABzShBbmRyZWFzIFJv Z2dlIDxhbmRyZWFzLnJvZ2dlQGJhcmVvcy5jb20+wsGUBBMBCAA+AhsDBQsJCAcCBhUKCQgL AgQWAgMBAh4BAheAFiEEzy/RixlEey5QwgdwADFHWIZr1Z4FAmd797QFCQlrokYACgkQADFH WIZr1Z4D9BAAnSfgRKl3DcmLPwx6lK3bsdiZxCiGUS7vthLikx94EXXF2H8SYwIm9cx+HXCs QpfxacL2dNfC7rPxrn20azxXOGajKPieGZrEqTUpCdQiTeRMgj51xBFHrsFOL1o7X/7ZSu8q dKAI9zm9OwiNPanwzU4D4hF9djmXEI4ZdAxVao3fAATQyb4k0YioWEQ1u3LN2MYceityBKfR gruivjQ66fhXSDXoQGjvCpCPeClqB1KE89fjex2ODslhtzjgQnRxiAcBpaegZsBoi2DvNSAM SH7Xv7WGf6RdyKy0tQsdmsc45MmkTjZOxV9cxG4HXbqLidUVvwc4MoojvmTXAAiMfEIHB90u kdpb3BB/wjGZdUfpa6Y7ad6hJ90WnUcttajC/fgjhTdpLFdOn7cn5Ml2J4JIUJ36kh00YWnw zy/r0oqsoYupzKB0qL7tyMdeA1fA//wMz5rhCsEySmaKs9bY1fFcz33FpAoa647Lbk3aLvlp XSfaq0fcd78QefEXRNtoUGPgFNBZDR3tGdU/+r0m+gRCLkTwBGhrfFr83Syrh2hljv+gx8s1 Vlzmk9Me0zkl56hwgcgazHBMBhTXX3AJcop5Ky0huUlMJ1PSE6JY8beYoiUe293uuuKUJ8YE C+rF8ZougpAACrTT4CnScY4lF/AGoSVZW1wVTQ02KfLfEArOwU0EYdK8bgEQAMHhATxRc6kI Gbq/1oPv6KQRKwBXka1Wj9x+bB4ayvYJECV7DkS0+QphdiwLHkZ9IwQm/IoRwe4Lq5szmj8V 8e2+UDTCzlv3imwkYB+0x+M47BmDxsqv+3U9zvu2WAlThunQ00DFD1Jha50Qpp3fxUooFE13 yBjVy2eUF/dQznNQgbSIU7bZNDaTzWSvjLzrfkR/VBM3/1R2ZOgpXyG6ruIgY4g/rhPIX9KS +yusVnwyiz0H0lRro4DGpTO1fkGjsUa3QbyMHjFAPpkYnO7hhmYT2H4e+p7YO0P1c5S/rWpO byY8FKCNYwI1yob9BTaov7osaYzcswlTRr7JxGyUuddmJWS390BJVezWyAYgq2nHiXA8Doqc C/a1Jlbsnsb4XDs9IuVxHekqaamy47dT7FWsJUj6IdKJzqrA5QI3vJXmfJ40Vwb8RukU6Kv+ C8tNoubTz8QIg5On5Qa8sFcu65tNCLNpGfIY5f+wYDRgtEYeNM/9RUgYKDfuhQXoy9eKDSMa +iNLLasysBC4LkpwDeTdKRP2ApOZEpqoBUUJXzH7efWpl00JS8ILV+9d5AGP47mkG0Sf0DW/ 7P+RB32H81/CWGQ0QCYg7nqpmhY1/fgL3H3L2knYHIK/96HkP2hrOpKzQamBfbPchEtIXNEc 4LQPa4kRhN26Wf4EG03+LLtlABEBAAHCwXwEGAEIACYCGwwWIQTPL9GLGUR7LlDCB3AAMUdY hmvVngUCZ3v33gUJCWuicAAKCRAAMUdYhmvVnizVEACIAjaguEllnBsTnbyVnm2F6CJlq5Wf 906R76iBEl8OmEmyhX+/5MGIC80W6URNSRSMY/2MC9gOS81pzhZENbm+7J0DGDiXFz6aBewG 10KNA7Actg7VRovs/RLcgDhYghs5mbCezalHVuZ6D27AH/rpxkolSaX+U0Lxt7iv1/8E+0a6 pUGx5JIGSNK4nYGL0FSAK4sDxd8H6c/SiwKVd2eL/yq7jfmfu38xZOGoE+hljd24Ch1XkZKA BNDyYHATVUc2zM7RabnE9x079f7ssnZsF9NIPdp+yyir1iDi1MSddyWrjLHNLPsLAUuCQ6Bi 5KmzgC9V9uSmmg976mUEoPxl5VBsES2HvNC/eDHqT2mXZxWjgwiN7MoI6tyJm9KiHglCEf7d aYjDbZSsc6let3J16SsSeN0TqdYFWoUW3jR77y6lcQKFZygedilQaAsJ44QSYXjAOS0Mmn4T tJfpaaY0oQuOf+Rs7BoG1sa3avAzlUsZ67X2Bkf1PPwBNvQYTwgLtOE9B5yYVBol+/0vMHUl GJl5G5Njjs2a7FNXzFjIaML8rGt4MaDO687BdnXdF4WjWTyoVlUYSb0p9W0+wX3cl8/jLYZc h7JozcsdNjpKLCSltYQYAdz4HHforo7P5wV0CgcWFEk5cTrMX3KsJm02++MNj61mAC5HYCSf v64Nmg== Organization: Bareos GmbH & Co. KG In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Am 11.03.25 um 11:13 schrieb Christoph Berg: > Is this only hitting Bareos and not every other application > distributed by RH itself? If so, why? That depends on what you call "hitting". As far as I can tell the warning messsage "/lib64/libpq.so.5: no version information available (required by ...)" is emitted by ld.so for everything that was linked at build-time to redhat's version of libpq and then run with pgdg's libpq5. In in a fresh rhel9 ubi container you can do the following: # dnf install rhel-9-x86_64/pgdg-redhat-repo-42.0-46PGDG.noarch.rpm # dnf install libpq5 # dnf install postfix-pgsql # ldd /usr/lib64/postfix/postfix-pgsql.so (here you'll see the message) It seems like you will not see the warning message in postfix, because postfix-pgsql.so is loaded using dlopen(). When dynamic linking occurs during dlopen() ld.so will not write a message to stderr, of course. It looks like most (if not all) of the things in the rhel repos that link to libpq are plugins that will be loaded with dlopen(). At least I couldn't quickly find any program that directly links to libpq. Nevertheless, the problem Bareos hits can be reproduced easily: 1. set up a rhel9 system without PGDG 2. install compiler + libpq-devel 3. build "libpq Example Program 1" [1] and link with RH's libpq 4. move resulting program to a system with libpq5 from PGDG and run it When libpq is dynamically linked during initial program setup by ld.so, you will see the warning message. Best Regards, Andreas [1] https://www.postgresql.org/docs/current/libpq-example.html -- Andreas Rogge andreas.rogge@bareos.com Bareos GmbH & Co. KG Phone: +49 221-630693-86 http://www.bareos.com Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 Komplementär: Bareos Verwaltungs-GmbH Geschäftsführer: Stephan Dühr, Jörg Steffens, Philipp Storz