Re: New repo RPMs

On 4/12/19 4:09 PM, Michael Vermaes wrote:
> (Apologies for not replying to the original message directly ...)
>
> On Thu, Apr 11, 2019 at 00:20 AM Devrim Gündüz <devrim(at)gunduz(dot)org> wrote:
>>
>> 1. Instead of having separate repo RPMs per PostgreSQL major version, we now
>> have one single repo RPM that supports all supported PostgreSQL releases. This
>> will make our lives easier. The new packages obsolete the current ones.
>>
>> 2. While working on it, bumped up the repo RPM version to 42. Hopefully that
>> will be the end of the "The repo RPM is 10-4, how can I find 10-7 repo rpm, so
>> that I can install PostgreSQL 10.7?" type questions. We were tired of answering
>> that.
>
> This seems like it will be a good improvement (I'll admit to being someone that
> used to be confused about the relationship :)

It's certainly very useful to have a single canonical URL to point to when
installing the repo RPM.

> I noticed that after updating several of our 9.6 CentOS 7 servers to the new
> repo RPM, that python-psycopg2 now brings in postgresql11-libs as a dependency.
> So after fully updating, both postgresql96-libs and postgresql11-libs are
> installed.
>
> Would this be expected behaviour after these changes?

This had me wondering too - while provisioning a fresh VM running Pg10,
installing "python-psycopg2" immediately after installing the repo RPM
(from the Pg10 directory) resulted in this:

Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
(...)
Resolving Dependencies
--> Running transaction check
---> Package python-psycopg2.x86_64 0:2.7.5-1.rhel7.1 will be installed
--> Processing Dependency: postgresql11-libs for package: python-psycopg2-2.7.5-1.rhel7.1.x86_64
--> Processing Dependency: libpq.so.5()(64bit) for package: python-psycopg2-2.7.5-1.rhel7.1.x86_64
--> Running transaction check
---> Package postgresql11-libs.x86_64 0:11.2-2PGDG.rhel7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
python-psycopg2 x86_64 2.7.5-1.rhel7.1 pgdg11 155 k
Installing for dependencies:
postgresql11-libs x86_64 11.2-2PGDG.rhel7 pgdg11 360 k

Transaction Summary
================================================================================
Install 1 Package (+1 Dependent package)

Total download size: 515 k
Installed size: 1.9 M
Downloading packages:
Public key for postgresql11-libs-11.2-2PGDG.rhel7.x86_64.rpm is not installed
--------------------------------------------------------------------------------
Total 240 kB/s | 515 kB 00:02
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-11

The installed key here is "/etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG-10".

I was able to work around this by installing the "postgresql10-libs" package before
"python-psycopg2" (which then pulled in the "postgresql11-libs" package with no issues),
but it ain't pretty :(.

Regards

Ian Barwick

--
Ian Barwick https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services