Re: New repo RPMs - Mailing list pgsql-pkg-yum

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