Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15 - Mailing list pgsql-general
| From | Magnus Hagander |
|---|---|
| Subject | Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15 |
| Date | |
| Msg-id | CABUevEyvNqJHmbYKWfgu0EAReYSRr4R7FKHmqU9JCFd6e-0zaQ@mail.gmail.com Whole thread Raw |
| In response to | Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15 (Andrej <andrej.groups@gmail.com>) |
| Responses |
Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
|
| List | pgsql-general |
On Sun, May 11, 2025 at 11:23 PM Andrej <andrej.groups@gmail.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/InReleaseFor 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.listdeb 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.
pgsql-general by date: