Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-pkg-debian-owner+archive@lists.postgresql.org>)
	id 1pzjhu-0005Th-MP
	for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 18 May 2023 19:54:38 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-pkg-debian-owner+archive@lists.postgresql.org>)
	id 1pzjht-00033r-Kj
	for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 18 May 2023 19:54:37 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <cb@df7cb.de>)
	id 1pzjex-0000pg-Ms
	for pgsql-pkg-debian@lists.postgresql.org; Thu, 18 May 2023 19:51:35 +0000
Received: from feynman.df7cb.de ([195.49.152.168])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <cb@df7cb.de>)
	id 1pzjet-000aky-Ri
	for pgsql-pkg-debian@lists.postgresql.org; Thu, 18 May 2023 19:51:35 +0000
Received: from msg.df7cb.de (unknown
 [IPv6:2a02:908:1482:3660:2ae7:2867:64d8:87dc])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange ECDHE (P-256) server-signature ECDSA (P-384) server-digest
 SHA384)
	(Client did not present a certificate)
	by feynman.df7cb.de (Postfix) with ESMTPSA id 4QMgb72jlXz3F0n;
	Thu, 18 May 2023 21:51:31 +0200 (CEST)
Date: Thu, 18 May 2023 21:51:31 +0200
From: Christoph Berg <myon@debian.org>
To: James Coleman <jtc331@gmail.com>,
	Bradford Boyle <bradford.d.boyle@gmail.com>
Cc: pgsql-pkg-debian@lists.postgresql.org
Subject: Re: Download failures on apt archive
Message-ID: <ZGaBw0kzRQuv6MZ2@msg.df7cb.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CAOMoQbTRacJcoUdvsvBn-TE=+5Nu14kA1vB5zMpgDLjCHJC6RQ@mail.gmail.com>
 <CAAaqYe9DM=c-JRt=JWDSERJCDgDoZbt4hV3yJWYNsPAPpvTzDA@mail.gmail.com>
List-Id: <pgsql-pkg-debian.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-pkg-debian@lists.postgresql.org>
List-Owner: <mailto:pgsql-pkg-debian-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-pkg-debian>
Archived-At: 
 <https://www.postgresql.org/message-id/ZGaBw0kzRQuv6MZ2%40msg.df7cb.de>
Precedence: bulk

Re: James Coleman
> Hello,
> 
> We've been trying to do direct downloads from the apt archive (e.g.
> [1]) and many of the files fail to download with an AccessDenied error
> with XML from S3 like:
> 
> <Error>
> <Code>AccessDenied</Code>

Hmm, admittedly I've never tried to recheck if all the package links
worked after the initial setup, so it's well possible something went
wrong in the years since then.

I'll do some QA there tomorrow. Thanks for reporting!

Re: Bradford Boyle
> Hi James,
> 
> apt-archive.p.o is hosted via an AWS S3 bucket which doesn't include/generate
> index lists (e.g, index.html) which is why [1] doesn't work.

There are manually uploaded index.html files generated from the
database mentioned earlier.

> Using this, we can see why [2] isn't working for you -- there is no libpq-dev
> in bullseye-pgdg-archive, the package is libpq5-dev.

libpq-dev is correct, the 5 is only in libpq5.deb.

Christoph