Subject: Re: latest libpq5 package conflicts with Redhat package
To: pgsql-admin@lists.postgresql.org
References: <8a1f23b2-3eba-ac0c-19bb-a3b20409a5bb@uvic.ca>
 <a841559c-b0d5-b2c1-14c2-ac7abd57cf12@gmail.com>
From: Evan Rempel <erempel@uvic.ca>
Message-ID: <0ec32782-50db-dbac-f3f5-db2cb9cfdd07@uvic.ca>
Date: Thu, 6 May 2021 08:01:14 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.8.1
MIME-Version: 1.0
In-Reply-To: <a841559c-b0d5-b2c1-14c2-ac7abd57cf12@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/0ec32782-50db-dbac-f3f5-db2cb9cfdd07%40uvic.ca>
Precedence: bulk

No. I'm not trying to install 9.2

Welcome to the way that Redhat releases an OS and keeps everything at 
the same "version number" for the life of the OS. They backport all 
security patches, but the version stays the same. I have no choice in 
the version or the packaged libraries that Redhat provide.

Since the Redhat postgresql-libs package contains the extra libraries it 
is likely that some other tool in the Redhat package set will depend on 
these libraries and will break.

Evan.

On 5/6/21 7:37 AM, Ron wrote:
> Notice: This message was sent from outside the University of Victoria 
> email system. Please be cautious with links and sensitive information.
>
>
> Am I missing something, or are you trying to install a version (9.2) that
> has been unsupported for 4.5 years?
>
> On 5/6/21 9:32 AM, Evan Rempel wrote:
>> Redhat 7.9
>>
>> $ rpm -ql postgresql-libs | grep -v share | sort
>> /usr/lib64/libecpg_compat.so.3
>> /usr/lib64/libecpg_compat.so.3.4
>> /usr/lib64/libecpg.so.6
>> /usr/lib64/libecpg.so.6.4
>> /usr/lib64/libpgtypes.so.3
>> /usr/lib64/libpgtypes.so.3.3
>> /usr/lib64/libpq.so.5
>> /usr/lib64/libpq.so.5.5
>>
>> $ rpm -q --provides postgresql-libs
>> libecpg.so.6()(64bit)
>> libecpg_compat.so.3()(64bit)
>> libpgtypes.so.3()(64bit)
>> libpq.so = 9.2.24-4.el7_8
>> libpq.so.5()(64bit)
>> postgresql-libs = 9.2.24-4.el7_8
>> postgresql-libs(x86-64) = 9.2.24-4.el7_8
>>
>>
>> From PGDG
>>
>> $ rpm -ql libpq5 | grep -v share | sort
>> /usr/lib64/libpq.so
>> /usr/lib64/libpq.so.5
>> /usr/lib64/libpq.so.5.13
>>
>> $ rpm -q --provides libpq5
>> libpq >= 10.0
>> libpq.so.5
>> libpq.so.5()(64bit)
>> libpq.so.5(RHPG_10)(64bit)
>> libpq.so.5(RHPG_12)(64bit)
>> libpq.so.5(RHPG_9.6)(64bit)
>> libpq5 = 13.2-10PGDG.rhel7
>> libpq5(x86-64) = 13.2-10PGDG.rhel7
>> postgresql-libs >= 9.2
>>
>> There are additional libraries in the Redhat package that seem to be
>> missing in the libpq5 so removing the Redhat package in favor of the
>> libpq5 package would introduce some missing dependencies.
>>
>> Other packages from the pgdg-common repository have strict 
>> dependencies on
>> the libpq5 package.
>>
>> Does anyone have suggestions on how to handle this conflict?
>>
>>