Re: Postgres 16 missing from apt repo?

[Adrian Klaver]

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.kla...@aklaver.com

Re: Postgres 16 missing from apt repo?

[Peter J. Holzer]

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.
|_|_) ||
| |   | h...@hjp.at |-- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |   challenge!"


signature.asc
Description: PGP signature

Re: Postgres 16 missing from apt repo?

[Adrian Klaver]

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
 


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.kla...@aklaver.com

Re: Postgres 16 missing from apt repo?

[Tamal Saha]

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


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?

Regards,
Tamal



On Thu, Feb 22, 2024 at 3:10 PM Adrian Klaver 
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=3471932=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.kla...@aklaver.com
>
>

Re: Postgres 16 missing from apt repo?

[Adrian Klaver]

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/ 
 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.kla...@aklaver.com

Postgres 16 missing from apt repo?

[Tamal Saha]

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