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.klaver@aklaver.com
