postgresql-client 14 is not installable on Ubuntu 14: wrong IP / DNS name

[Ruslan Dautkhanov]

%sh sudo apt update && sudo apt upgrade -y; sudo apt-get install -y postgresql-client

The following additional packages will be installed:
  postgresql-client-14 postgresql-client-common
Suggested packages:
  postgresql-14 postgresql-doc-14
The following NEW packages will be installed:
  postgresql-client postgresql-client-14 postgresql-client-common
0 upgraded, 3 newly installed, 0 to remove and 12 not upgraded.
Need to get 1,254 kB of archives.
After this operation, 4,177 kB of additional disk space will be used.
Get:1 http://archive.ubuntu.com/ubuntu jammy/main amd64 postgresql-client-common all 238 [29.6 kB]
Ign:2 http://archive.ubuntu.com/ubuntu jammy-updates/main amd64 postgresql-client-14 amd64 14.9-0ubuntu0.22.04.1
Get:3 http://archive.ubuntu.com/ubuntu jammy/main amd64 postgresql-client all 14+238 [3,292 B]
Err:2 http://security.ubuntu.com/ubuntu jammy-updates/main amd64 postgresql-client-14 amd64 14.9-0ubuntu0.22.04.1
  404 Not Found [IP: 91.189.91.81 80]
Fetched 32.8 kB in 8s (3,880 B/s)

[Paride Legovini (paride)]

Hello, if you executed that command exactly as pasted in the bug description, the `apt update` command didn't execute correctly (you didn't paste the output of that part). I strongly believe this is not a bug in Ubuntu.

[Ruslan Dautkhanov (tagar)]

This is an issue we observed before, it’s between ubuntu and cloud provider.

Long story short, ubuntu server ip changed, and dns will take some time (usually 5-30 mins) to pick new ip up. That’s why you see 404 error. A workaround is to forcibly refresh the apt cache

mv /etc/apt/sources.list /etc/apt/sources.list.bak

apt update #invalidate the cache

mv /etc/apt/sources.list.bak /etc/apt/sources.list

apt update #forcibly refresh

Anything we can do to fix this permanently?

[Launchpad Janitor (janitor)]

[Expired for postgresql-common (Ubuntu) because there has been no activity for 60 days.]