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