Feedback-ID: i76984098:Fastmail
Message-ID: <4cbe2e53-0bf3-4a89-bd81-dfb124b4c36e@aklaver.com>
Date: Sun, 11 May 2025 14:13:00 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main
 15
To: Andrej <andrej.groups@gmail.com>,
 postgresql Forums <pgsql-general@postgresql.org>
References: <CACMx3pNvi=kxdo1L9zjrp-Qhm9QpdtqxyJO2WriosV_sXQPLSQ@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CACMx3pNvi=kxdo1L9zjrp-Qhm9QpdtqxyJO2WriosV_sXQPLSQ@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/4cbe2e53-0bf3-4a89-bd81-dfb124b4c36e%40aklaver.com>
Precedence: bulk

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