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

Hi Adrian,

Thank you for the super-quick response!

> > 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.
>
> 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?

Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes
concise.

http://www.georgedillon.com/web/html_email_is_evil.shtml
http://www.catb.org/jargon/html/email-style.html