Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15

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(dot)klaver(at)aklaver(dot)com