Re: BUG #18833: libpq.so doesn't contain declared symbol in rpm --provides

Alvaro Herrera <alvherre@alvh.no-ip.org>

From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: bruno@ioda-net.ch, pgsql-pkg-yum@lists.postgresql.org
Date: 2025-03-10T17:08:35Z
Lists: pgsql-bugs
On 2025-Mar-06, PG Bug reporting form wrote:

> The following bug has been logged on the website:
> 
> Bug reference:      18833
> Logged by:          Bruno Friedmann
> Email address:      bruno@ioda-net.ch
> PostgreSQL version: 17.4
> Operating system:   rhel 9.5
> Description:        

It's been suggested that this belongs in the pgsql-pkg-yum mailing list.


> if you check the following
> ```
> rpm -q libpq5 --provides
> libpq >= 10.0
> libpq.so.5
> libpq.so.5()(64bit)
> libpq.so.5(RHPG_10)(64bit)
> libpq.so.5(RHPG_11)(64bit)
> libpq.so.5(RHPG_12)(64bit)
> libpq.so.5(RHPG_13)(64bit)
> libpq.so.5(RHPG_14)(64bit)
> libpq.so.5(RHPG_15)(64bit)
> libpq.so.5(RHPG_9.6)(64bit)
> libpq5 = 17.4-1PGDG.rhel9
> libpq5(x86-64) = 17.4-1PGDG.rhel9
> postgresql-libs >= 9.2
> ```
> 
> You find that you are 100% similar (extended to certain version) to what is
> provided as operating system
> ```
> rpm -q libpq --provides
> libpq = 13.20-1.el9_5
> libpq(x86-64) = 13.20-1.el9_5
> libpq.so.5()(64bit)
> libpq.so.5(RHPG_10)(64bit)
> libpq.so.5(RHPG_12)(64bit)
> libpq.so.5(RHPG_13)(64bit)
> libpq.so.5(RHPG_9.6)(64bit)
> postgresql-libs = 13.20-1.el9_5
> ```
> 
> This should allow a software build against rhel libpq-devel to be satisfied
> with pgdg packaged libpq
> but the following message appears like the following
> ```
> bareos-dir: /usr/pgsql-14/lib/libpq.so.5: no version information available
> (required by /usr/lib64/bareos/libbareossql.so.24)
> ```
> 
> when you use strings on both library, pgdg doesn't contains the expected
> symbol
> pgdg
> ```
> strings /usr/lib64/libpq.so.5 | grep RHPG
> ```
> versus
> rhel 13.20
> ```
> strings /usr/lib64/libpq.so.5 | grep RHPG
> RHPG_9.6
> RHPG_10
> RHPG_12
> RHPG_13
> ```
> 



-- 
Álvaro Herrera               48°01'N 7°57'E  —  https://www.EnterpriseDB.com/
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)