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

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

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?

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?

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?