Postgres Pro
Downloads
Home   >   mailing lists

libpq 11.10 / 11.11 are not propertly released for bionic - Mailing list pgsql-pkg-debian

From Saif Hakim
Subject libpq 11.10 / 11.11 are not propertly released for bionic
Date
Msg-id CAHcM7L13D4MAByVkMz35BKtfDQB2rTXP88hrFj5TLHfSm16F3w@mail.gmail.com
Whole thread Raw
Responses Re: libpq 11.10 / 11.11 are not propertly released for bionic
List pgsql-pkg-debian
Tree view
Hey there,

I noticed that version 11.11 of libpq5 and libpq-dev were released yesterday, but the release seems incomplete.

libpq-dev_11.11-1.pgdg18.04+1_amd64.deb            11-Feb-2021 10:39              165700
libpq-dev_11.11-1.pgdg18.04+1_arm64.deb            11-Feb-2021 10:40              154792
libpq-dev_11.11-1.pgdg18.04+1_i386.deb             11-Feb-2021 10:39              175292
libpq-dev_11.11-1.pgdg18.04+1_ppc64el.deb          11-Feb-2021 10:40              179288

However, in https://apt.postgresql.org/pub/repos/apt/dists/bionic-pgdg/11/binary-amd64/ , Packages was last updated on 12-Nov-2020 12:10, listing filenames for the two packages for the *11.10* release:
pool/11/p/postgresql-11/libpq-dev_11.10-1.pgdg18.04+1_amd64.deb
pool/11/p/postgresql-11/libpq5_11.10-1.pgdg18.04+1_amd64.deb

Furthermore, the referenced files are *not* found in the pool. The only 11.10 files are as follows:
libpq-dev_11.10-1.pgdg110+1+b1_amd64.deb           20-Nov-2020 09:24              164420
libpq-dev_11.10-1.pgdg110+1+b1_arm64.deb           20-Nov-2020 09:24              161744
libpq-dev_11.10-1.pgdg110+1+b1_ppc64el.deb         20-Nov-2020 09:24              179880
libpq-dev_11.10-1.pgdg110+1+b2_amd64.deb           04-Jan-2021 12:10              164424
libpq-dev_11.10-1.pgdg110+1+b2_arm64.deb           04-Jan-2021 12:10              161788

This prevents me from installing libpq 11 on bionic, as reproduced via `docker run -it ubuntu:18.04 bash` below:

root@62d4e1ddd8bf:/# apt-get update -qq && apt-get install -qq curl gnupg2
...
root@62d4e1ddd8bf:/# curl -sf https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -
OK
root@62d4e1ddd8bf:/# echo 'deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg 11' >> /etc/apt/sources.list.d/postgresql.list
root@62d4e1ddd8bf:/# apt-cache policy libpq5
libpq5:
  Installed: (none)
  Candidate: 10.15-0ubuntu0.18.04.1
  Version table:
     10.15-0ubuntu0.18.04.1 500
        500 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages
        500 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages
     10.3-1 500
        500 http://archive.ubuntu.com/ubuntu bionic/main amd64 Packages
root@62d4e1ddd8bf:/# apt-get update -qq
root@62d4e1ddd8bf:/# apt-cache policy libpq5
libpq5:
  Installed: (none)
  Candidate: 11.10-1.pgdg18.04+1
  Version table:
     11.10-1.pgdg18.04+1 500
        500 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/11 amd64 Packages
     10.15-0ubuntu0.18.04.1 500
        500 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 Packages
        500 http://security.ubuntu.com/ubuntu bionic-security/main amd64 Packages
     10.3-1 500
        500 http://archive.ubuntu.com/ubuntu bionic/main amd64 Packages
root@62d4e1ddd8bf:/# apt-get install libpq5=11\*
Reading package lists... Done
Building dependency tree
Reading state information... Done
Selected version '11.10-1.pgdg18.04+1' (PostgreSQL for Debian/Ubuntu repository:bionic-pgdg [amd64]) for 'libpq5'
The following NEW packages will be installed:
  libpq5
0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
Need to get 169 kB of archives.
After this operation, 767 kB of additional disk space will be used.
Err:1 http://apt.postgresql.org/pub/repos/apt bionic-pgdg/11 amd64 libpq5 amd64 11.10-1.pgdg18.04+1
  404  Not Found [IP: 87.238.57.227 80]
E: Failed to fetch http://apt.postgresql.org/pub/repos/apt/pool/11/p/postgresql-11/libpq5_11.10-1.pgdg18.04+1_amd64.deb  404  Not Found [IP: 87.238.57.227 80]
E: Unable to fetch some archives, maybe run apt-get update or try with --fix-missing?

I *think* I can manually install these packages via the following, but I'm not sure if there are any other release-related issues:
curl https://apt.postgresql.org/pub/repos/apt/pool/11/p/postgresql-11/libpq-dev_11.11-1.pgdg18.04%2B1_amd64.deb -o /tmp/libpq-dev.debcurl https://apt.postgresql.org/pub/repos/apt/pool/11/p/postgresql-11/libpq5_11.11-1.pgdg18.04%2B1_amd64.deb -o /tmp/libpq.debdpkg -i /tmp/libpq-dev.deb
dpkg -i /tmp/libpq.deb

Thanks,
Saif

pgsql-pkg-debian by date:

Previous
From: apt.postgresql.org Repository Update
Date:
Subject: pgbackrest updated to version 2.32-1.pgdg+1
Next
From: Christoph Berg
Date:
Subject: Re: libpq 11.10 / 11.11 are not propertly released for bionic