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 1siWzn-005lvL-Qr for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:30:47 +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 1siWzl-007t7O-Vf for pgsql-general@arkaria.postgresql.org; Mon, 26 Aug 2024 10:30:46 +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 1siWzl-007t63-G3 for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:30:46 +0000 Received: from mail-vk1-xa33.google.com ([2607:f8b0:4864:20::a33]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1siWzj-001VFY-0R for pgsql-general@lists.postgresql.org; Mon, 26 Aug 2024 10:30:44 +0000 Received: by mail-vk1-xa33.google.com with SMTP id 71dfb90a1353d-4fd01b38dd7so1466781e0c.0 for ; Mon, 26 Aug 2024 03:30:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1724668242; x=1725273042; darn=lists.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=vPGYgjuLYmVgHQCkf82kss8GyM1hc6rN2FQtJqby/Oo=; b=hq3KKB/S+Vk66twtpeOHEKOzvIgu1FelPTwOfHP7pOJxtmDJpDYz8SAz47q9coKkUq 0C3y9Lyw2Xy5tMfJdMaH6W/ry6ev4A6pYOSGe+9U0ia7jAaK0t0uUQ9lCt/o5P2b+SZZ sODeBxDvbDpv89FeTK71+5K8IrGVNZ9qk8mLSOrAVUQrLvENkkgjEaAxFUlduhDD5q7D 2UYD627kkoQe68Ie6OMRT70MHzCzO3PvjBKJe7u60g6lPm5VwCe2djsxyyQUWNf4Nam+ Njdyhjx0Bmp/MDFRP4LxGQjuNUOPCi/gjdOYoKjFt4TLLLg3yVZuzicq/B54XN0jTkMv twLg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1724668242; x=1725273042; 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=vPGYgjuLYmVgHQCkf82kss8GyM1hc6rN2FQtJqby/Oo=; b=LR8mSYtzTSl65fZ3Q0aV0tlkkbKfxaNz2DwCZo4DJSE+HBHYDwiDMa66o4oVXTvZPu H9YhfAkZFb0Bd/KSyXMbMlENa+1BNBT69FcCSSOGil8mnLTiqk1cHYJKWZfqYu2XH1aA mPe3w/wFfqoN998FJ0eslWMi5fe8M0CG3y60OWXEtTtcycKoZjo8k1m7F/Oo4Rwjo9RH If6B7eontP5s5wZzLxSbkmBgGjbW1Ol15q0F01j7pI4hkw+k4c0ugtHMS9riDFqmGAfh BgsqUmz8scQjlnql3/lEFlWQAnuCbCArm4BOK7W1FzeistCHHWytmXXYtMqITcv5Ibbf 5tDg== X-Forwarded-Encrypted: i=1; AJvYcCXGn9EfhdSBOLy089uk+e3umwLC0vXN0Kh1o+8Y8xQTB5wiFmHaZyn5+ri4UE6RYRfr45qGSEZK742yQ0He@lists.postgresql.org X-Gm-Message-State: AOJu0YzesReTpzQUuJ1zNLZ13uepmU1CwSG21S9IakMYXVdkngYr82rm Dlg4gBAlWWcEUi3hmrad179tDVl3+CRHDzVSCXtCen+8W9bBzOYu4dGB1FXqo6Hyrx9IZdm6kUB 6odCbucsVzp5/NVCrmU/xEqLC4eNk0Oqf X-Google-Smtp-Source: AGHT+IHrs3zEwoOn0GES+yhPeR9YxAsMa+6j12jxQ3MwF1T0knobmPxHDticqgF0buSI+d3wlImSFw9vPXlQGv4n2jA= X-Received: by 2002:a05:6122:3107:b0:4f2:ea44:fd36 with SMTP id 71dfb90a1353d-4fd1a39da8dmr12110115e0c.0.1724668241987; Mon, 26 Aug 2024 03:30:41 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Kashif Zeeshan Date: Mon, 26 Aug 2024 15:30:29 +0500 Message-ID: Subject: Re: Issue Installing PostgreSQL 17 on Ubuntu 22.04 (Jammy) To: Jyoti Saxena , postgre Content-Type: multipart/alternative; boundary="000000000000eb4d840620939d2c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000eb4d840620939d2c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Aug 26, 2024 at 3:19=E2=80=AFPM Jyoti Saxena wrote: > Hi Kashif, > > Thank you for the instructions. I followed the steps provided to set up > the repository and install PostgreSQL. However, after completing the setu= p, > the system installed PostgreSQL 16.4 instead of the expected PostgreSQL 1= 7. > The version installed is psql (PostgreSQL) 16.4 (Ubuntu 16.4-1.pgdg22.04+= 1). > > Here are the steps I followed: > > > 1. Installed curl and ca-certificates. > 2. Set up the repository key and configuration as instructed. > 3. Ran apt-get update. > 4. Executed sudo apt -y install postgresql. > > The repository seems to have installed the latest available version as > PostgreSQL 16.4. Could you please advise if there is a different reposito= ry > I should use for PostgreSQL 17, or if additional steps are needed to > specifically target version 17? > So the last version available is PG16, which means PG17 is still not there. If you require PG17 beta for Testing purposes then you can install it from code, which is available on following https://www.postgresql.org/ftp/source/v17beta3/ > > Thank you for your assistance. > > Best regards, > Jyoti > > On Mon, Aug 26, 2024 at 12:35=E2=80=AFPM Kashif Zeeshan > wrote: > >> Hi Jyoti >> >> Make sure you have done the following repo setup >> >> sudo apt install curl ca-certificates >> sudo install -d /usr/share/postgresql-common/pgdg >> sudo curl -o /usr/share/postgresql-common/pgdg/apt.postgresql.org.asc >> --fail https://www.postgresql.org/media/keys/ACCC4CF8.asc >> >> # Create the repository configuration file: >> sudo sh -c 'echo "deb >> [signed-by=3D/usr/share/postgresql-common/pgdg/apt.postgresql.org.asc] >> https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > >> /etc/apt/sources.list.d/pgdg.list' >> >> >> Also once the above is done then execute following >> apt-get update >> >> then execute the following command and it shd install the latest version >> of PG in this case PG17. >> sudo apt -y install postgresql >> >> Regards >> Kashif Zeeshan >> >> On Mon, Aug 26, 2024 at 11:52=E2=80=AFAM Jyoti Saxena >> wrote: >> >>> Hi, >>> >>> I=E2=80=99m encountering an issue while trying to install PostgreSQL 17= on my >>> Ubuntu 22.04 (Jammy) system. I followed the installation instructions f= rom >>> the official PostgreSQL website >>> https://www.postgresql.org/download/linux/ubuntu/. >>> >>> When I run the command sudo apt -y install postgresql-17, I receive the >>> following message: >>> >>> Reading package lists... DoneBuilding dependency tree... DoneReading st= ate information... DonePackage postgresql-17 is not available, but is refer= red to by another package.This may mean that the package is missing, has be= en obsoleted, or is only available from another source. >>> >>> Here=E2=80=99s what I=E2=80=99ve already tried: >>> >>> 1. Updated the package list with sudo apt update. >>> >>> 2. Verified that the PostgreSQL Apt Repository is added correctly with >>> >>> deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main. >>> >>> 3. Checked available packages using apt-cache search postgresql-17. >>> >>> 4. Despite these steps, I=E2=80=99m unable to install PostgreSQL 17. C= ould you >>> please advise on how to resolve this issue or if there's something I mi= ght >>> be missing? >>> >>> Thank you in advance for your help! >>> >>> Best regards, >>> >>> Jyoti >>> >> --000000000000eb4d840620939d2c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Mon, Aug 26, 2024 at 3:19=E2=80=AF= PM Jyoti Saxena <jyotisaxen= a.mcm@gmail.com> wrote:
Hi Kashif,

Thank you for the instruc= tions. I followed the steps provided to set up the repository and install P= ostgreSQL. However, after completing the setup, the system installed Postgr= eSQL 16.4 instead of the expected PostgreSQL 17. The version installed is p= sql (PostgreSQL) 16.4 (Ubuntu 16.4-1.pgdg22.04+1).

Here are the step= s I followed:

  1. Installed curl and ca-certificates.
  2. Se= t up the repository key and configuration as instructed.
  3. Ran apt-ge= t update.
  4. Executed sudo apt -y install postgresql.
The rep= ository seems to have installed the latest available version as PostgreSQL = 16.4. Could you please advise if there is a different repository I should u= se for PostgreSQL 17, or if additional steps are needed to specifically tar= get version 17?

So the last versi= on available is PG16, which means PG17 is still not there.
If you= require PG17 beta for Testing purposes then you can install it from code, = which is available on following=C2=A0


Thank you for your assistance.

Best = regards,=C2=A0
Jyoti

On Mon, Aug 26, 2024 at 12:35=E2=80=AFPM = Kashif Zeeshan <kashi.zeeshan@gmail.com> wrote:
Hi=C2=A0Jyoti

Make sure you have done the following repo setup

sudo apt install curl ca-certificates
sudo install -d /usr/share/postg= resql-common/pgdg
sudo curl -o /usr/share/postgresql-common/pgdg/apt.pos= tgresql.org.asc --fail https://www.postgresql.org/media/keys/ACCC4CF8= .asc

# Create the repository configuration file:
sudo sh -c &= #39;echo "deb [signed-by=3D/usr/share/postgresql-common/pgdg/apt.postg= resql.org.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)= -pgdg main" > /etc/apt/sources.list.d/pgdg.list'
=

Also once the above is done then execute foll= owing
apt-get update

then execute the fo= llowing command and it shd install the latest version of PG in this case PG= 17.
sudo apt -y install postgresql

R= egards
Kashif Zeeshan

<= div dir=3D"ltr" class=3D"gmail_attr">On Mon, Aug 26, 2024 at 11:52=E2=80=AF= AM Jyoti Saxena <jyotisaxena.mcm@gmail.com> wrote:

Hi,

I=E2=80=99m encountering an issue while trying to install P= ostgreSQL 17 on my Ubuntu 22.04 (Jammy) system. I followed the installation= instructions from the official PostgreSQL website https://www.postgresql.org/download/linux/ubuntu/.

When I run the command sudo apt -y install postgresql-17, I= receive the following message:

Reading package lists..=
. Done
Building dependency tree... Done
Reading state information... Done
Package postgresql-17 is not available, but =
is referred to by another package.
This may mean that the package is missing, h=
as been obsoleted, or is only available from another source.

Here=E2=80=99s what I=E2=80=99ve already tried:

=C2=A01. Updated the package list with sudo apt update.

=

=C2=A02. Verified that the PostgreSQL Apt Repository is add= ed correctly with=C2=A0

deb http://apt.postgresql.org/pub/repos/apt/ jammy-pgdg main.=C2=A0

3. Checked available packages = using apt-cache search postgresql-17.

=C2=A04. Despite t= hese steps, I=E2=80=99m unable to install PostgreSQL 17. Could you please a= dvise on how to resolve this issue or if there's something I might be m= issing?

Thank you in advance for your help!

Best regards,

Jyoti

--000000000000eb4d840620939d2c--