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

On Sun, May 11, 2025 at 11:23 PM Andrej <andrej(dot)groups(at)gmail(dot)com> wrote:

> Hi Adrian,
>
> Thank you for the super-quick response!
>

Just a quick check-back on this: has this issue basically resolve itself by
now, or does it still show up?

> > 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/
>
>
> I see ... but was there anything new in the process of publishing them?
>
>
>>
>> > 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
>
> For browser sessions yes, not inside the sources-file
> `/etc/apt/sources.list.d/apt_postgresql_org_pub_repos_apt.list` ... they're
> structured like this, for example:
>
> cat apt_postgresql_org_pub_repos_apt.list
> deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
>
>
>> > 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.
>>
>

Something weird here. You have bookworm-pgdg in your repository config
file, but the error is from focal-pgdg.. Have you somehow ended up with two
repos configured?

>
>> 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?
>>
>
> Me neither, I'll confess - possibly a version in use that *didn't* receive
> an update?
>

If you still have the issue, or f it reappears, can you please provider the
header output from basically a "curl -I <url>" for th different URLs
involved at the time of failure?

And also note the exact timestamp of when you're doing it, to correlate
with logs.

--
Magnus Hagander
Me: https://www.hagander.net/ <http://www.hagander.net/>
Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/>