On 5/11/25 13:59, Andrej wrote:
Hi,
We have two clusters of postgres running, and a couple of machines have
local postgres databases installed via ansible, using ANXS.postgresql.
This has been working fine for years, installing varied versions of
postgres, doing upgrades & migrations without a hitch.
Since last week we're seeing odd errors which look like they're caused
by repo:
May 8th a round of new releases where made:
https://www.postgresql.org/about/news/postgresql-175-169-1513-1418-and-1321-released-3072/
a) W: An error occurred during the signature verification. The
repository is not updated and the previous index files will be used. GPG
error: http://apt.postgresql.org/pub/repos/apt
<http://apt.postgresql.org/pub/repos/apt> bookworm-pgdg InRelease:
Shouldn't the above be?:
https://apt.postgresql.org/pub/repos/apt/dists/bookworm-pgdg/InRelease
b) E: Failed to fetch
http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/Packages.bz2 <http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/Packages.bz2> File has unexpected size (350884 != 350996). Mirror sync in progress? [IP: v.w.x.y[1] 3142]
Hashes of expected file:
- Filesize:350996 [weak]
-
SHA256:b946f1cb499ffca9331f532cea373ca5f5d39551fdc156effef354e001a5b865
- SHA1:7aabca4a364ee2b4b891465b02f60d7609b79f8f [weak]
- MD5Sum:738420fcc2da36f7728502eb2809aa43 [weak]
Release file created at: Mon, 28 Apr 2025 16:16:01 +0000
E: Some index files failed to download. They have been ignored, or old
ones used instead.
From here:
http://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/main/binary-amd64/
Packages.bz2 09-May-2025 19:58 350884
Not sure where the Filesize:350996 [weak] and Release file created at:
Mon, 28 Apr 2025 16:16:01 +0000 is coming from?
[1] v.w.x.y - we use an apt-cacher-ng to proxy package installations to
be a good citizen and not pummel upstream machines (not just postgres,
but both Ubuntu and Debian as well). I have confirmed that the content
on the cacher is identical to what I see on apt.postgresql.org
<http://apt.postgresql.org> when using a browser.
Cheers,
Andrej
--
Adrian Klaver
adrian.kla...@aklaver.com
