pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgres 16 missing from apt repo?
6+ messages / 3 participants
[nested] [flat]

* Postgres 16 missing from apt repo?
@ 2024-02-22 21:29 Tamal Saha <tamal@appscode.com>
  2024-02-22 23:10 ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Tamal Saha @ 2024-02-22 21:29 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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...;
for the last 4-5 days. Is this a known issue? Thanks!

Regards,
Tamal

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres 16 missing from apt repo?
  2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
@ 2024-02-22 23:10 ` Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-22 23:18   ` Re: Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Adrian Klaver @ 2024-02-22 23:10 UTC (permalink / raw)
  To: Tamal Saha <tamal@appscode.com>; pgsql-general@lists.postgresql.org

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...; 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






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres 16 missing from apt repo?
  2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  2024-02-22 23:10 ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
@ 2024-02-22 23:18   ` Tamal Saha <tamal@appscode.com>
  2024-02-22 23:57     ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-24 16:43     ` Re: Postgres 16 missing from apt repo? Peter J. Holzer <hjp-pgsql@hjp.at>
  0 siblings, 2 replies; 6+ messages in thread

From: Tamal Saha @ 2024-02-22 23:18 UTC (permalink / raw)
  To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general@lists.postgresql.org

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...
<https://mailtrack.io/l/26db4dd8a92ebdf155ab4f61cbc7ae8d4863445b?url=https%3A%2F%2Fgithub.com%2Fdocke...;

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 <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...;
> 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
>
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres 16 missing from apt repo?
  2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  2024-02-22 23:10 ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-22 23:18   ` Re: Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
@ 2024-02-22 23:57     ` Adrian Klaver <adrian.klaver@aklaver.com>
  1 sibling, 0 replies; 6+ messages in thread

From: Adrian Klaver @ 2024-02-22 23:57 UTC (permalink / raw)
  To: Tamal Saha <tamal@appscode.com>; +Cc: pgsql-general@lists.postgresql.org

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... <https://mailtrack.io/l/26db4dd8a92ebdf155ab4f61cbc7ae8d4863445b?url=https%3A%2F%2Fgithub.com%2Fdocke...;
> 
> 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






^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres 16 missing from apt repo?
  2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  2024-02-22 23:10 ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-22 23:18   ` Re: Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
@ 2024-02-24 16:43     ` Peter J. Holzer <hjp-pgsql@hjp.at>
  2024-02-24 16:52       ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  1 sibling, 1 reply; 6+ messages in thread

From: Peter J. Holzer @ 2024-02-24 16:43 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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!"

Attachments:

  signature.asc (application/pgp-signature, 832B) download

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Postgres 16 missing from apt repo?
  2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  2024-02-22 23:10 ` Re: Postgres 16 missing from apt repo? Adrian Klaver <adrian.klaver@aklaver.com>
  2024-02-22 23:18   ` Re: Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
  2024-02-24 16:43     ` Re: Postgres 16 missing from apt repo? Peter J. Holzer <hjp-pgsql@hjp.at>
@ 2024-02-24 16:52       ` Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Adrian Klaver @ 2024-02-24 16:52 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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%40...

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






^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2024-02-24 16:52 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-02-22 21:29 Postgres 16 missing from apt repo? Tamal Saha <tamal@appscode.com>
2024-02-22 23:10 ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-02-22 23:18   ` Tamal Saha <tamal@appscode.com>
2024-02-22 23:57     ` Adrian Klaver <adrian.klaver@aklaver.com>
2024-02-24 16:43     ` Peter J. Holzer <hjp-pgsql@hjp.at>
2024-02-24 16:52       ` Adrian Klaver <adrian.klaver@aklaver.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox