Thread: Postgres 16 missing from apt repo?
Hi,
I can't find the Postgres 16 folder in https://apt.postgresql.org/pub/repos/apt/pool/ for the last 4-5 days. Is this a known issue? Thanks!
Regards,
Tamal
On 2/22/24 13:29, Tamal Saha wrote: > Hi, > I can't find the Postgres 16 folder in > https://apt.postgresql.org/pub/repos/apt/pool/ > <https://mailtrack.io/l/5afb5f83fab81e3ff7e312ccb5f762a6aca1f1d9?url=https%3A%2F%2Fapt.postgresql.org%2Fpub%2Frepos%2Fapt%2Fpool%2F&u=3471932&signature=db336b9bf87dd299> forthe last 4-5 days. Is this a known issue? Thanks! From https://apt.postgresql.org/pub/repos/apt/pool/README "Almost all packages in the apt.postgresql.org repository, including the PostgreSQL server packages for all versions, are located in the "main" component (aka directory). The other N.N components here (like "9.2") merely serve as stowage for the non-default-version library packages built from server packages. The libpq packages from the older PostgreSQL versions live here, as well as those from beta and devel branches. The libpq packages from the newest stable PostgreSQL version live in "main" as well. This is why the N.N directories here only contain few package, and most of the time there will not even be a directory for the "current" stable PostgreSQL version. " Are you having issues installing/upgrading Postgres 16? > > Regards, > Tamal -- Adrian Klaver adrian.klaver@aklaver.com
Hi Adrian,
Thanks for the response. I am trying to build the postgres:16.1 docker image and it fails. This is the docker file (I am not associated with Docker Inc.).
I get the following error
6.976 Package postgresql-16 is not available, but is referred to by another package.
6.976 This may mean that the package is missing, has been obsoleted, or
6.976 is only available from another source
6.976
6.980 E: Version '16.1-1.pgdg120+1' for 'postgresql-16' was not found
6.976 This may mean that the package is missing, has been obsoleted, or
6.976 is only available from another source
6.976
6.980 E: Version '16.1-1.pgdg120+1' for 'postgresql-16' was not found
How may I fix this?
Regards,
Tamal
Tamal
On Thu, Feb 22, 2024 at 3:10 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 2/22/24 13:29, Tamal Saha wrote:
> Hi,
> I can't find the Postgres 16 folder in
> https://apt.postgresql.org/pub/repos/apt/pool/
> <https://mailtrack.io/l/5afb5f83fab81e3ff7e312ccb5f762a6aca1f1d9?url=https%3A%2F%2Fapt.postgresql.org%2Fpub%2Frepos%2Fapt%2Fpool%2F&u=3471932&signature=db336b9bf87dd299> for the last 4-5 days. Is this a known issue? Thanks!
From
https://apt.postgresql.org/pub/repos/apt/pool/README
"Almost all packages in the apt.postgresql.org repository, including the
PostgreSQL server packages for all versions, are located in the "main"
component (aka directory). The other N.N components here (like "9.2")
merely serve as stowage for the non-default-version library packages
built from server packages. The libpq packages from the older PostgreSQL
versions live here, as well as those from beta and devel branches. The
libpq packages from the newest stable PostgreSQL version live in "main"
as well.
This is why the N.N directories here only contain few package, and most
of the time there will not even be a directory for the "current" stable
PostgreSQL version.
"
Are you having issues installing/upgrading Postgres 16?
>
> Regards,
> Tamal
--
Adrian Klaver
adrian.klaver@aklaver.com
On 2/22/24 15:18, Tamal Saha wrote: > Hi Adrian, > Thanks for the response. I am trying to build the postgres:16.1 docker > image and it fails. This is the docker file (I am not associated with > Docker Inc.). > https://github.com/docker-library/postgres/blob/d416768b1a7f03919b9cf0fef6adc9dcad937888/16/bookworm/Dockerfile#L93 <https://mailtrack.io/l/26db4dd8a92ebdf155ab4f61cbc7ae8d4863445b?url=https%3A%2F%2Fgithub.com%2Fdocker-library%2Fpostgres%2Fblob%2Fd416768b1a7f03919b9cf0fef6adc9dcad937888%2F16%2Fbookworm%2FDockerfile%23L93&u=3471932&signature=5f13fc03adc60ed9> > > I get the following error > > 6.976 Package postgresql-16 is not available, but is referred to by > another package. > 6.976 This may mean that the package is missing, has been obsoleted, or > 6.976 is only available from another source > 6.976 > 6.980 E: Version '16.1-1.pgdg120+1' for 'postgresql-16' was not found > > How may I fix this? https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_only_specific_packages_from_this_repository Where are older versions of the packages? The *-pgdg distributions only contain the most recent version of each package. Older versions are available in the archive at https://apt-archive.postgresql.org/ https://apt-archive.postgresql.org/ Archive of all released packages on apt.postgresql.org The archive also contains all versions of all packages that have been part of some DIST-pgdg distribution on apt.postgresql.org. These distributions are called DIST-pgdg-archive here. The archive is updated daily; the Packages/Sources files contain all versions at once. /etc/apt/sources.list entry for the archive repository: deb https://apt-archive.postgresql.org/pub/repos/apt DIST-pgdg-archive main deb-src https://apt-archive.postgresql.org/pub/repos/apt DIST-pgdg-archive main > > Regards, > Tamal > > > -- Adrian Klaver adrian.klaver@aklaver.com
On 2024-02-22 15:18:37 -0800, Tamal Saha wrote: > Thanks for the response. I am trying to build the postgres:16.1 docker image > and it fails. This is the docker file (I am not associated with Docker Inc.). > https://github.com/docker-library/postgres/blob/ > d416768b1a7f03919b9cf0fef6adc9dcad937888/16/bookworm/Dockerfile#L93 I don't know about docker images. My answer is for Debian or Ubuntu systems in general. > I get the following error > > 6.976 Package postgresql-16 is not available, but is referred to by another > package. > 6.976 This may mean that the package is missing, has been obsoleted, or > 6.976 is only available from another source > 6.976 > 6.980 E: Version '16.1-1.pgdg120+1' for 'postgresql-16' was not found > > How may I fix this? The current version is 16.2, not 16.1. You appear to have cached an obsolete index. Use "apt update" to update the index. hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!"
Attachment
On 2/24/24 08:43, Peter J. Holzer wrote: > On 2024-02-22 15:18:37 -0800, Tamal Saha wrote: >> Thanks for the response. I am trying to build the postgres:16.1 docker image >> and it fails. This is the docker file (I am not associated with Docker Inc.). >> https://github.com/docker-library/postgres/blob/ >> d416768b1a7f03919b9cf0fef6adc9dcad937888/16/bookworm/Dockerfile#L93 > > I don't know about docker images. My answer is for Debian or Ubuntu > systems in general. > > >> I get the following error >> >> 6.976 Package postgresql-16 is not available, but is referred to by another >> package. >> 6.976 This may mean that the package is missing, has been obsoleted, or >> 6.976 is only available from another source >> 6.976 >> 6.980 E: Version '16.1-1.pgdg120+1' for 'postgresql-16' was not found >> >> How may I fix this? > > The current version is 16.2, not 16.1. You appear to have cached an > obsolete index. No the OP was looking for that version per their Docker file from this post: https://www.postgresql.org/message-id/CAA%3DcNux52hkHTJ%2BXRci6OzLMQ1LoMcHE%3DcvXjwwWvYi%3DPt61Vw%40mail.gmail.com Where: ENV PG_VERSION 16.1-1.pgdg120+1 <...> apt-get build-dep -y "postgresql-$PG_MAJOR=$PG_VERSION"; \ apt-get source --compile "postgresql-$PG_MAJOR=$PG_VERSION"; \ I pointed them at the repo you get archived versions if that is really what they want. See: https://www.postgresql.org/message-id/c7b7aa36-10f7-4b65-9ea9-7f48f285429d%40aklaver.com > > Use "apt update" to update the index. > > hp > -- Adrian Klaver adrian.klaver@aklaver.com