MIME-Version: 1.0
From: Andrej <andrej.groups@gmail.com>
Date: Mon, 12 May 2025 08:59:35 +1200
Message-ID: <CACMx3pNvi=kxdo1L9zjrp-Qhm9QpdtqxyJO2WriosV_sXQPLSQ@mail.gmail.com>
Subject: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15
To: postgresql Forums <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000b71dbe0634e27a57"
Archived-At: <https://www.postgresql.org/message-id/CACMx3pNvi%3Dkxdo1L9zjrp-Qhm9QpdtqxyJO2WriosV_sXQPLSQ%40mail.gmail.com>
Precedence: bulk

--000000000000b71dbe0634e27a57
Content-Type: text/plain; charset="UTF-8"

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:

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 bookworm-pgdg InRelease: Splitting
up
/var/lib/apt/lists/partial/apt.postgresql.org_pub_repos_apt_dists_bookworm-pgdg_InRelease
into data and signature failed
W: Failed to fetch
http://apt.postgresql.org/pub/repos/apt/dists/bookworm-pgdg/InRelease
 Splitting up
/var/lib/apt/lists/partial/apt.postgresql.org_pub_repos_apt_dists_bookworm-pgdg_InRelease
into data and signature failed
W: Some index files failed to download. They have been ignored, or old ones
used instead.--

b) E: Failed to fetch
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.

[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 when using a
browser.


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

--000000000000b71dbe0634e27a57
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi,</div><div><br></div><div>We have two clusters of =
postgres running, and a couple of machines have local postgres databases in=
stalled via ansible, using ANXS.postgresql. This has been working fine for =
years, installing varied versions of postgres, doing upgrades &amp; migrati=
ons without a hitch.</div><div><br></div><div>Since last week we&#39;re see=
ing odd errors which look like they&#39;re caused by repo:</div><div><br></=
div><div>a) <font face=3D"monospace">W: An error occurred during the signat=
ure verification. The repository is not updated and the previous index file=
s will be used. GPG error: <a href=3D"http://apt.postgresql.org/pub/repos/a=
pt">http://apt.postgresql.org/pub/repos/apt</a> bookworm-pgdg InRelease: Sp=
litting up /var/lib/apt/lists/partial/apt.postgresql.org_pub_repos_apt_dist=
s_bookworm-pgdg_InRelease into data and signature failed</font></div><font =
face=3D"monospace">W: Failed to fetch <a href=3D"http://apt.postgresql.org/=
pub/repos/apt/dists/bookworm-pgdg/InRelease">http://apt.postgresql.org/pub/=
repos/apt/dists/bookworm-pgdg/InRelease</a> =C2=A0Splitting up /var/lib/apt=
/lists/partial/apt.postgresql.org_pub_repos_apt_dists_bookworm-pgdg_InRelea=
se into data and signature failed<br>W: Some index files failed to download=
. They have been ignored, or old ones used instead.<span class=3D"gmail_sig=
nature_prefix">--</span></font><div><br></div><div>b) <font face=3D"monospa=
ce">E: Failed to fetch <a href=3D"http://apt.postgresql.org/pub/repos/apt/d=
ists/focal-pgdg/main/binary-amd64/Packages.bz2">http://apt.postgresql.org/p=
ub/repos/apt/dists/focal-pgdg/main/binary-amd64/Packages.bz2</a> =C2=A0File=
 has unexpected size (350884 !=3D 350996). Mirror sync in progress? [IP: v.=
w.x.y[1] 3142]</font></div><font face=3D"monospace">=C2=A0 =C2=A0Hashes of =
expected file:<br>=C2=A0 =C2=A0 - Filesize:350996 [weak]<br>=C2=A0 =C2=A0 -=
 SHA256:b946f1cb499ffca9331f532cea373ca5f5d39551fdc156effef354e001a5b865<br=
>=C2=A0 =C2=A0 - SHA1:7aabca4a364ee2b4b891465b02f60d7609b79f8f [weak]<br>=
=C2=A0 =C2=A0 - MD5Sum:738420fcc2da36f7728502eb2809aa43 [weak]<br>=C2=A0 =
=C2=A0Release file created at: Mon, 28 Apr 2025 16:16:01 +0000<br>E: Some i=
ndex files failed to download. They have been ignored, or old ones used ins=
tead.</font><div><br></div><div>[1] v.w.x.y=C2=A0 - we use an apt-cacher-ng=
 to proxy package installations to be a good citizen and not pummel upstrea=
m 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 <a h=
ref=3D"http://apt.postgresql.org">apt.postgresql.org</a> when using a brows=
er.</div><div><br></div><div><br></div><div><br></div><div>Cheers,</div><di=
v>Andrej</div><div><br></div><div><br></div><div><br></div><div><br></div><=
div><span class=3D"gmail_signature_prefix"></span><br><div dir=3D"ltr" clas=
s=3D"gmail_signature" data-smartmail=3D"gmail_signature">Please don&#39;t t=
op post, and don&#39;t use HTML e-Mail :} =C2=A0Make your quotes concise.<b=
r><br><a href=3D"http://www.georgedillon.com/web/html_email_is_evil.shtml" =
target=3D"_blank">http://www.georgedillon.com/web/html_email_is_evil.shtml<=
/a><br><a href=3D"http://www.catb.org/jargon/html/email-style.html" target=
=3D"_blank">http://www.catb.org/jargon/html/email-style.html</a></div></div=
></div>

--000000000000b71dbe0634e27a57--