Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uEE8K-004rg9-9V for pgsql-general@arkaria.postgresql.org; Sun, 11 May 2025 21:22:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uEE8J-00BPbs-3g for pgsql-general@arkaria.postgresql.org; Sun, 11 May 2025 21:22:51 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uEE8I-00BPbk-K9 for pgsql-general@lists.postgresql.org; Sun, 11 May 2025 21:22:50 +0000 Received: from mail-oo1-xc36.google.com ([2607:f8b0:4864:20::c36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uEE8F-001JrT-2P for pgsql-general@postgresql.org; Sun, 11 May 2025 21:22:49 +0000 Received: by mail-oo1-xc36.google.com with SMTP id 006d021491bc7-6021e3daeabso1866108eaf.3 for ; Sun, 11 May 2025 14:22:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1746998567; x=1747603367; darn=postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=X4ZNhYvO47q0RB2R5xcfV0YhxEfRkgzmGCNk5LN9foQ=; b=jqmYQzVC8/7Dj5tS8L74w9tYaI+3Mfqw34fJ0c749zQcXuSCjfsEIbT5Noey19dQel OJaI7z1daEoYUAnS2vk7A7C047uV1NZ1RjQwWGDTDdmzpeiXnIZHMtCRABhxMENuguh5 9QK3Wb45W8xfR0N3Ja3kwmE7WQeJA0Ox9a9ddcL5+J/8WL9fNrFbRwK5tClXxHGn/UuW w2S5DrKT9yG7zyTZanQQgpZaiK1doBg2nR7KeYmwJ5x4pE9j5zX7kpoNKeep4zoz/og0 QxjlHFe2a7ztB7brdXL6DuH8zYvESwrGjtmoEBXUzxQxmF0s97rQdQNFjhZfI8oePsIE UKfw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746998567; x=1747603367; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=X4ZNhYvO47q0RB2R5xcfV0YhxEfRkgzmGCNk5LN9foQ=; b=keOLg+rGOvb3R/kfW9TyuGoP7U3LDMHZisVKtkrqREb2qWTUIaGb9TVRRlUOD55Rv1 WyYCrjoNyHDW0A4wQhLHFgnndkoV3eI2eTRCAHvbcsH9M5h6NEHu+EBLzKidQSU/bjno 9ORh5kQwVIKTYvseg7/WNJfDc7PpvtaCiDZUd6RuR/Ss49CCLPu4aJsAuPutQrxbH4+x +iHa1tOc2MePkqI7L1JY13vmrO/TlCfGP/59pBBUdH1hEeLGLruDnDBrYFYw4ppewSYC SLMwnGy7KBtgHJTcNcZu4FQLh1sfN/MdvdrQjdvsYuQMDPWVEYgNx+lWngUJSHwTe8eP 8Uaw== X-Gm-Message-State: AOJu0Ywb7IqvLor9NpGlSY1yi7KnYVxK11a3D3sPd5urFq/2jx86tAMm zkvNDZ4w93hJSfUv98KMKm8ZDUGQ3+khtiC/acdOtcW2Xued7yC9A2eJHemu3OvFLdPQxKEsR87 +d+6nIs1NtluXgPn4IZvTooUpdn9U10aP X-Gm-Gg: ASbGncs05L60xJj5If63CXOOP9IsSPFqKS9XvBf+Y2XZOnhIzQ439tLLW37SKfS+Z1H wSdBGAELjABcJWBElGAVY8Z8DCU7P3YgxjS0jHPnozISspiA/befTPVymm8KczFGtGUv879tvwW fyiAhrm01YXAkU7/rc+r3g/CKHwFh5+0ndjHRRiRsVRO8= X-Google-Smtp-Source: AGHT+IHYqtQU/6GRGYNj7vlRsF1J3cs5JnRK9Kz23b5TPMsXxJA+VHocO4Ez+ejRzYa00YwxQ9QeIfVDkyh2rIRtu50= X-Received: by 2002:a05:6820:983:b0:604:ae66:1e9b with SMTP id 006d021491bc7-6084c118041mr6375980eaf.8.1746998567308; Sun, 11 May 2025 14:22:47 -0700 (PDT) MIME-Version: 1.0 References: <4cbe2e53-0bf3-4a89-bd81-dfb124b4c36e@aklaver.com> In-Reply-To: <4cbe2e53-0bf3-4a89-bd81-dfb124b4c36e@aklaver.com> From: Andrej Date: Mon, 12 May 2025 09:22:36 +1200 X-Gm-Features: AX0GCFsyiTU13-3sTq8VFyQ0H1PpzVz6ZWwHxVLPkOfhRIaIDM-5jI6JVKD7T1s Message-ID: Subject: Re: deb http://apt.postgresql.org/pub/repos/apt/ bookworm-pgdg main 15 To: postgresql Forums , Adrian Klaver Content-Type: multipart/alternative; boundary="0000000000000711280634e2cdd6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000711280634e2cdd6 Content-Type: text/plain; charset="UTF-8" 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 > > 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 --0000000000000711280634e2cdd6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Adrian,

Thank you f= or the super-quick response!


=C2=A0
> We have two clusters of postgres running, and a couple of machines hav= e
> 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'r= e caused
> by repo:

May 8th a round of new releases where made:

https://ww= w.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?=C2=A0
=C2=A0

> a) W: An error occurred during the signature verification. The
> repository is not updated and the previous index files will be used. G= PG
> error: http://apt.postgresql.org/pub/repos/apt
> <http://apt.postgresql.org/pub/repos/apt> book= worm-pgdg InRelease:

Shouldn't the above be?:

https://apt.postgresql.org/pub= /repos/apt/dists/bookworm-pgdg/InRelease
For browser s= essions yes, not inside the sources-file `/etc/apt/sources.list.d/apt_postg= resql_org_pub_repos_apt.list` ... they're structured like this, for exa= mple:

cat=C2=A0apt_postgr= esql_org_pub_repos_apt.list
deb <= a href=3D"http://apt.postgresql.org/pub/repos/apt/">http://apt.postgresql.o= rg/pub/repos/apt/ bookworm-pgdg main 15


> b) E: Failed to fetch
> http://a= pt.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> =C2=A0File has unexpected size (350884 !=3D 350996). M= irror sync in progress? [IP: v.w.x.y[1] 3142]
>=C2=A0 =C2=A0 =C2=A0Hashes of expected file:
>=C2=A0 =C2=A0 =C2=A0 - Filesize:350996 [weak]
>=C2=A0 =C2=A0 =C2=A0 -
> SHA256:b946f1cb499ffca9331f532cea373ca5f5d39551fdc156effef354e001a5b86= 5
>=C2=A0 =C2=A0 =C2=A0 - SHA1:7aabca4a364ee2b4b891465b02f60d7609b79f8f [w= eak]
>=C2=A0 =C2=A0 =C2=A0 - MD5Sum:738420fcc2da36f7728502eb2809aa43 [weak] >=C2=A0 =C2=A0 =C2=A0Release 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.

=C2=A0From here:

http://apt.postgresql.org= /pub/repos/apt/dists/focal-pgdg/main/binary-amd64/

Packages.bz2=C2=A0 =C2=A0 =C2=A0 09-May-2025 19:58=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 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 *did= n't* receive an update?
=C2=A0
Cheers,
An= drej


--
Please d= on't top post, and don't use HTML e-Mail :} =C2=A0Make your quotes = concise.

http://www.georgedillon.com/web/html_email_is_e= vil.shtml
http://www.catb.org/jargon/html/email-style.html
--0000000000000711280634e2cdd6--